Create a Dynamic File Path in Power Query

In this I’ll share, how can you create a dynamic folder or a file path, both in Excel Power Query and in Power BI.

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

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[JoaoLojaPereira]

Thanks Goodly.

Honestly i looked through several videos online for this and yours was by far the best.

You were short methodical and clean. Not going back and forth with several alternate explanations during the main steps. Keep up the good work.

[creating...]

Been stuck for several days each 8 hours on this issue, you solved it in an instant, from A to Z solution in 10 minutes. Thank you.

[beastuzair]

Love you man I've been searching for this for last 3 days and solved my problem within 2 mins,
Great, Appreciated.

[erlendvanderveeken]

Most appreciative for this trick! Clear and concise. Seems to work with Sharepoint locations aswell!

[huongbui]

Tks so much! Its very very useful for me! I love how you edit the code in Power query of Power BI

[kauanreis]

This video save my life hahaha.
i needed to change file by file, now i can save excel files in different folders and use the path as filter in power query
many many many many thx

[bgn]

Thank you so much for this video! You just saved my life. I needed to share a file with my work colleague so she could refresh the data during my absence and publish to other departments in my company.
Only now I can go on holidays without taking my laptop with me.

[michaelstagner]

Thanks so much for sharing. Well done!

[perrymoen]

Thanks for posting, never considered the formula to tease out the file path!

[Nextwhatguru]

Thanks so much, this was helped in sharing my folder with others.

[martinslevi]

Great tutorial.


Would be great if someone could share how to retrieve the data from these files.
I know you have mentioned another video, I tried and could not make it work.

Anyone in this group that could share the file retrieving all the data in the file would be great.

Many thanks.

[immanjohn]

Thankyou very much for making this video brother, really useful.

[tomjoad]

This trick is so helpful - Thank you very much for sharing !!!!

[cesartonoli]

Thank you very much!! Excellent tip, helped me a lot

[MrAni]

Chandeep is the best of the best in PQ. So proud an Indian is leading the way ahead

[casinoguy]

Thanks for this trick.
Tricky part is to make on a file stored on a "One Drive" . Since the File Path formula gives you a web address and then through Power query you need to Login using Microsoft / Windows / Organizational Credentials.
It worked well for the 1st time when I chose the path for the Source as below
Source = & FileName)...
But failed on subsequent refresh, and returns a 404 error not found...
Any thoughts on how would you handle this?

[engahmedelbendary]

thx you for nice Video and for let your file

[legionssssss]

Hello there, thanks for the wonderful video.
I'm wondering if similar can be done in Excel VBA Vlookup Dynamic File Path, how would the code looks like?

[farooqueasad]

Thanks. How we can select more than one file dynamically to compare thos etwo files

[taufiqalibhai]

Thanks for the video. I tried something similar but I keep getting the Formula.Firewall error. The M Code that I am trying is as follows

let
Source = tbl_folderpathsettings,
Custom1 = tbl_folderpathsettings[Location]{List.PositionOf(tbl_folderpathsettings[Worksheet], "dtSales")},
Custom2 = Folder.Files(Custom1)
in
Custom2

Can you help