Data Loading Tricks in Power Query

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - Blog & Videos - - -

[vishaljhaveri]

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!

[dapperlink]

Haha! I’ve been taking original CSU data files and converting them to excel files and cringing on the upload speed. Thank you!

[matheusmascarenhas]

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.

[ziggle]

Excellent presentation! I am now a regular viewer.

[wayneedmondson]

Hi Chandeep. Awesome Power Query data loading tricks! Thanks for sharing them :)) Thumbs up!!

[GrainneDuggan_Excel]

Wow! The tips 1, 2 and 5 will solve the problem I ran into yesterday - THANKS!!

[yanago]

Chandeep, you are simply THE BEST! Thank you so much! 🙏

[GeorgeKlucsarits]

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!

[yemiakinwande]

Many Thanks, Chandeep, this is very helpful stuff 😊

[lalitvarma]

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?

[AnAnd-zloo]

very useful tricks, some of it I thought do not exist ..always created duplicate file an folders to for the dynamic folder path...🙏👌

[gopichand]

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

[zuhairalmutawa]

Thanks Chandeep, that was new to me and helpful.

[bhargavreddy]

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!

[torkunc]

Hi chandeep, is it possible to get data from a query that is stored in an another workbook?
Thanks and greetings from Turkey ❤

[amitsah]

Is there any way to refer cells in power bi like we do in excel?

[manishagrawal]

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?

[evelic]

How can the second trick, creating a folder path, can work with a sharepoint folder?

[RonDavidowicz]

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

[Marcogama]

Thank you!! it is posible to do a incremental refresh in power query with csv files?