How to Create a Dynamic File Path in Excel Power Query

How to Create a Dynamic File Path in Power Query

Pulling some information from different data sources is relatively easy nowadays. Thanks to Power Query as you don’t need to do it manually anymore or guessing an overwhelming VBA script just to get the right code for your data. Admit it or not, you’re investing so much time in searching for the formula/script in the internet and debugging errors just to get the task done.

This 10-minute video tutorial will help you how to make your data sources dynamic with the use of simple M script that you can add to refer to a named range in Excel. Let’s embrace this opportunity to learn new things.

Modify M Code:
Path = Excel.CurrentWorkbook(){[Name="Path"]}[Content]{0}[Column1],
Filename = Excel.CurrentWorkbook(){[Name="Filename"]}[Content]{0}[Column1],
Source = Excel.Workbook(File.Contents(Path & Filename), null, true),

Practice File:
https://drive.google.com/drive/folder...

"Creativity is the power to connect the seemingly unconnected."
William Plomer

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:
   / @romeocostillas  

YouTube Playlist:
   • Excel Keyboard Shortcut Control Combi...  

Or visit me on Facebook at   / excelbyromeocostillas  

See you there!


Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert
Microsoft Innovative Educator
Discrete Event Simulation Modeler


Tagalog Excel | Filipino | Pinoy Excel | Excel Tagalog Tutorial | Paano Gamitin ang Excel

#excelbyromeocostillas #Excel #ExcelTips