1. Applying a Dynamic Filter. [While using Excel file in Power Query, you can apply 'Date filter latest' on the "Date Created" column in Power Query. 2. Creating a Dynamic Path. [Making use of manage parameters and using that parameter to pass the path for your queries] 3. Data Load Performance [Excel vs CSV . Csv is better. Refer Chris Webb blog 4. Creating Helper table [Use of 'Enter Data'] 5. Creating a Date from the Name of a Excel File Thank You!
Hi Chandeep, thanks for another helpful set of tips. The helper table suggestion was timely; it was something I'd forgotten about but I just realized it would be the perfect solution for some static data that I need for my model. Really appreciate your content. Thanks!
Hi Chandeep, thank you for providing these tricks. I'm learning something new everytime I watch your videos. I have a followup question on the date extraction. If i do not wish to combine the file, but just extract the name / date from the filename, what changes should be made?
Hi chandeep, those tricks are awesome, Is there a way to load new files with out refreshing old files ie :-old files are already loaded in , This is taking so much time to load
Hi Chandeep, Trick no 2: here we are creating parameter for changeing source path right? We can able to change source in Data source settings under home tab right! Do both the options will work same or any differences we have. Thanks!
Hi ❤ that one too. Do you know whether there would be a difference between .CSV vs .txt performance wise. We extract data from SAP into Excel and then there are saved text tab delimited. As CSV uses ; as separator it can created problems when the posting text contains a ;
Hi Chandeep - brilliant tips Is there a way i can have a dynamic filter? I have column called ID - i have set a filter to remove a number of IDs and have hardcoded the IDs into the power query. Is it possible to have a table that has a list of all IDs and then use the ID column to filter out data from this table? That way all i have to do is amend 1 table if Ids need to be added or removed
Hi Chandeep, great video. I was working on a problem yesterday that I'll now use a couple of those types on. 1 question, is there a way of getting a dynamic path that is the current location off the Excel file? That way if the Excel file is copied to another location and the data files are in the new location too, power query will look for the data in the that folder and not the original location. Thanks, Ron
Does PowerQuery have a feature to link to a folder on a Sharepoint? I know each excel file has web path, but not sure if we can add path to the sharepoint folder.
Hi Chandeep, very nice as always...I am trying to load multiple pdf files which has multiple pages from a folder..In doing so, power query does not allow to select multiple pages (this feature is only available when I connect directly to one pdf.) Is there a way to overcome this?
Unfortunately our software exports old really big in size htm files, any ideas for faster loading, I already used a macro to convert those files to xlsx, but it takes time and it’s not practical, any other solutions ?
Hi Goodly: Question: I am trying to open one file in Power Query that the first raw is empty "blank" and does not have the Headers of the data, the data starts on raw 3, Power query does not read the data and says that the table is empty, how can I fix this issue? Thanks so much, Jose Luis
How can I get data in excel power query from An old 2004 Sybase ASE Database version 12.5.2 already deprecated fro Sap sybase and can’t find any online odbc connectors
Hi Chandeep, while loading excel files into power query few duplicate rows are getting added automatically into the report and i don't know how these extra rows are getting generated and due to this issue visualization values are not matching & please let me know how to resolve this issue
Hello need guidance Hello i m from commerce complting now graduatiom at 28 can i be a data analyst what are basic computer knwledge require to data analyst can u suggest the road map it will be grt help
Chandeep, thanks for the informative video. Is there a way to perform something like the so called "incremental refresh" in Power Query, so that when you add a new excel file in a folder of 10 already existing files, Power Query will only add the new file, not refreshing all files in the folder.
@@viveksharma4193 Still not! The only workaround method that I am using is opening the file with Power Query as another instance, then refreshing it. In this way, I am still able to work in another excel files while the PQ one is refreshing in the background.
Hi, I had loaded my query to table and have been using this for months. Now there is need to introduce another table and connect them. How can I load this query to connection?
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
1. Applying a Dynamic Filter. [While using Excel file in Power Query, you can apply 'Date filter latest' on the "Date Created" column in Power Query.
2. Creating a Dynamic Path. [Making use of manage parameters and using that parameter to pass the path for your queries]
3. Data Load Performance [Excel vs CSV . Csv is better. Refer Chris Webb blog
4. Creating Helper table [Use of 'Enter Data']
5. Creating a Date from the Name of a Excel File
Thank You!
Thank you
Haha! I’ve been taking original CSU data files and converting them to excel files and cringing on the upload speed. Thank you!
Enjoyed the path trick! It facilitates the life a lot, especially when you're building a dashboard on an environment that later might be changed.
Excellent presentation! I am now a regular viewer.
Hi Chandeep. Awesome Power Query data loading tricks! Thanks for sharing them :)) Thumbs up!!
Wow! The tips 1, 2 and 5 will solve the problem I ran into yesterday - THANKS!!
Hi Chandeep, thanks for another helpful set of tips. The helper table suggestion was timely; it was something I'd forgotten about but I just realized it would be the perfect solution for some static data that I need for my model. Really appreciate your content. Thanks!
Chandeep, you are simply THE BEST! Thank you so much! 🙏
Many Thanks, Chandeep, this is very helpful stuff 😊
One video, but full of tips. Thanks.
Glad you like them!
Thanks Chandeep, that was new to me and helpful.
Glad you liked it!
Hi Chandeep, thank you for providing these tricks. I'm learning something new everytime I watch your videos.
I have a followup question on the date extraction. If i do not wish to combine the file, but just extract the name / date from the filename, what changes should be made?
very useful tricks, some of it I thought do not exist ..always created duplicate file an folders to for the dynamic folder path...🙏👌
Thank you!! it is posible to do a incremental refresh in power query with csv files?
Hi chandeep, those tricks are awesome,
Is there a way to load new files with out refreshing old files
ie :-old files are already loaded in ,
This is taking so much time to load
This is possible using incremental refresh
Is there any way to refer cells in power bi like we do in excel?
Hi chandeep, is it possible to get data from a query that is stored in an another workbook?
Thanks and greetings from Turkey ❤
Hi Chandeep,
Trick no 2: here we are creating parameter for changeing source path right?
We can able to change source in Data source settings under home tab right!
Do both the options will work same or any differences we have.
Thanks!
Very good tips. Thanks!
Hi ❤ that one too. Do you know whether there would be a difference between .CSV vs .txt performance wise. We extract data from SAP into Excel and then there are saved text tab delimited. As CSV uses ; as separator it can created problems when the posting text contains a ;
Can say for sure that csv has faster performance as compared to excel.
Hi Chandeep - brilliant tips
Is there a way i can have a dynamic filter?
I have column called ID - i have set a filter to remove a number of IDs and have hardcoded the IDs into the power query. Is it possible to have a table that has a list of all IDs and then use the ID column to filter out data from this table?
That way all i have to do is amend 1 table if Ids need to be added or removed
See this
ruclips.net/video/eB-LBLS-BRg/видео.html
Thank you so much
Dude..... Thank u for this!
Very useful tutorial. Thank you :-)
heyy do you know a way to export power query to CSV - without loading query to table or pivottable ?
How can the second trick, creating a folder path, can work with a sharepoint folder?
Hi Chandeep, great video.
I was working on a problem yesterday that I'll now use a couple of those types on.
1 question, is there a way of getting a dynamic path that is the current location off the Excel file? That way if the Excel file is copied to another location and the data files are in the new location too, power query will look for the data in the that folder and not the original location.
Thanks, Ron
www.goodly.co.in/dynamic-file-path-power-query/
Very nice as always
Thanks 💚
Does PowerQuery have a feature to link to a folder on a Sharepoint? I know each excel file has web path, but not sure if we can add path to the sharepoint folder.
Yes u can
You are amazing thank you❤
Love those tricks ❤
Hi Chandeep, very nice as always...I am trying to load multiple pdf files which has multiple pages from a folder..In doing so, power query does not allow to select multiple pages (this feature is only available when I connect directly to one pdf.) Is there a way to overcome this?
Can you please link the data table video you were referencing?
Unfortunately our software exports old really big in size htm files, any ideas for faster loading, I already used a macro to convert those files to xlsx, but it takes time and it’s not practical, any other solutions ?
Hi Goodly: Question: I am trying to open one file in Power Query that the first raw is empty "blank" and does not have the Headers of the data, the data starts on raw 3, Power query does not read the data and says that the table is empty, how can I fix this issue? Thanks so much, Jose Luis
How can I get data in excel power query from An old 2004 Sybase ASE Database version 12.5.2 already deprecated fro Sap sybase and can’t find any online odbc connectors
may you elaborate a basket analysis in powerbi if you may - thanks so much
Hi Chandeep, while loading excel files into power query few duplicate rows are getting added automatically into the report and i don't know how these extra rows are getting generated and due to this issue visualization values are not matching & please let me know how to resolve this issue
I want to combine 8 files into one using merging. Usually i do vlookup.
So can i do this with power query and repeat same steps everyday
Hello need guidance
Hello i m from commerce complting now graduatiom at 28 can i be a data analyst
what are basic computer knwledge require to data analyst
can u suggest the road map it will be grt help
Chandeep, thanks for the informative video. Is there a way to perform something like the so called "incremental refresh" in Power Query, so that when you add a new excel file in a folder of 10 already existing files, Power Query will only add the new file, not refreshing all files in the folder.
do you have any solution for this .. ????? i'm also facing this issue so long.
@@viveksharma4193 Still not! The only workaround method that I am using is opening the file with Power Query as another instance, then refreshing it. In this way, I am still able to work in another excel files while the PQ one is refreshing in the background.
Hi, I had loaded my query to table and have been using this for months. Now there is need to introduce another table and connect them. How can I load this query to connection?
Sir if I have a folder having Name as Date
How we use that name into power query
Hi chandeep, need your one help as i want to download only top 1000 rows. How I can set this
Use the Table.Skip Function in Power Query
This should give you some ideas - ruclips.net/video/c8HQOCbJAzs/видео.html
Sir pls make a video on Table.buffer
Great !
Thanks!
great tricks
he bro i have problem with my power Bi i am unable to load data i dont know whats problem can you suggest me any solution to it
How do I stop loading queries all at once?
Great tricks