cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hcze
Helper I
Helper I

Dynamic Data Source

Hi,

 

I am using an Excel file stored on Sharepoint site and I would like to keep the folder dynamic.

It currently hits an error during data refresh on Power BI Service.

 

Here is my code:

strFolder = TblFolder{0}[Data Folder],
Source = Excel.Workbook(Web.Contents(strFolder & "Alibaba.xlsm"), null, true),

 

Appreciate your help.

 

hcze

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@hcze 
You can create a query parameter with foldernames. Then apply the parameter to code, make the str folder = the parameter name (Folder Name in the example). Something like:

 

strFolder = TblFolder{0}[Folder Name]

Source = Excel.Workbook(Web.Contents(strFolder & "Alibaba.xlsm"), null, true),

 

Vpazhenmsft_1-1632986496742.png

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
V-pazhen-msft
Community Support
Community Support

@hcze 
You can create a query parameter with foldernames. Then apply the parameter to code, make the str folder = the parameter name (Folder Name in the example). Something like:

 

strFolder = TblFolder{0}[Folder Name]

Source = Excel.Workbook(Web.Contents(strFolder & "Alibaba.xlsm"), null, true),

 

Vpazhenmsft_1-1632986496742.png

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors