How to create parameters via data load in power bi

[Anonymous]

Hi Team, How to achieve below scenario in power Bi. I have to load data through folders in power bi by using parametrs.

[v-shex-msft · Accepted solution]

HI @Anonymous,

You can create a query parameter with text type, then copy the data connection folder path to the parameter and use this parameter to replace the raw connection string.

After these steps, you can modify the query parameter value to change the data source path. (notice: the new path files show has the same data structure as the old one or you need to manly fix the cached data structure not match issue)

Raw query table:

let
    Source= Folder.Files("D:/xxx/xxx/")
in
    Source

Parameterize connection string:

let
    Source= Folder.Files(parameter1)
in
    Source

Reference link:

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev  
Regards,
Xiaoxin Sheng

[amitchandak]

@Anonymous , I think you are looking for connection as parameter , discussed by guyinacube in this video https://www.youtube.com/watch?v=OnaDJkGOmIE