The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
34 | |
19 | |
19 | |
17 | |
13 |