Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All,
I am using Folder connection as a source and I need to specify the folder name in Excel File and Power Query load automatically the files under this folder but I don't know how to do it ?
To resume I need to pass the connection to the folder source as variable.
For Exemple to load files 2019 :
Folder |
C:\Input\2019 |
Next Time I will change this value to load data 2020
Folder |
C:\Input\2020 |
How to this please In Power Query?
Any help will be appreciated.
Taddi 🙂
Solved! Go to Solution.
Please see this article. Basically, you make a new text parameter in query editor (called "folderpath" for example) and in the formula bar for your source step change "C:\Folder2019" to just folderpath (no quotes, since it is already a text parameter).
Using Variables for File Locations - Power BI Tips and Tricks
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please see this article. Basically, you make a new text parameter in query editor (called "folderpath" for example) and in the formula bar for your source step change "C:\Folder2019" to just folderpath (no quotes, since it is already a text parameter).
Using Variables for File Locations - Power BI Tips and Tricks
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks Mahoneypat