cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Taddi10
Helper III
Helper III

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 🙂

1 ACCEPTED SOLUTION
mahoneypat
Microsoft
Microsoft

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Microsoft
Microsoft

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Thanks Mahoneypat 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors