Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.