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 ...
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
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
Thanks Mahoneypat