Forum Discussion
Configure Folder name as a parameter ?
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 🙂
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
2 Replies
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