Configure Folder name as a parameter ?

[Taddi10]

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 🙂

[mahoneypat · Accepted 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

[Taddi10]

Thanks Mahoneypat