Power bi

[Maha16]

My source data excel files ( around 17 files) is in one teams folder. So by using SharePoint folder connector , imported that data to power bi desktop and created the report. But now , the source data are going to maintain in another teams folder by maintaining previous excel files format. So want to make my power bi point to the new location. I have tried creating parameters and in that it accepting only root url of SharePoint site. So by going to each table' s source step and changing the folder path is the only way? Or any easy way is there. If yes can you please provide it.

[Maha16]

My old excel files are  present in one SharePoint root url. There the path is , shared documents- general - Power Bi Demo- excel files folder. And my new excel files  are present in different SharePoint root url .there the path is, shared documents-general- excel files for power bi.  So created parameter for root url of old excel files. And datasource settings,changed source  to use this parameter. And then tried replacing the parameter with root url of new excel files. But throwing error that key didn't match.

Tried keeping the same folder names as is from old excel files in new excel files. Even again getting error

[Anonymous]

Hi @Maha16 ,

Do you want to switch to different folders with parameter? You can add all folder names to the parameter and then replace the folder name with the parameter.

Here is a link about the method for your reference. Solved: Dynamic File Path - Microsoft Fabric Community

Best regards,

Mengmeng Li

[Maha16]

New teams folder is present in different SharePoint root url. In this case , what should I do. Can you tell me

[Idrissshatila]

hello @Maha16 ,

did you try to change the path from the datasource settings ?

if it didn't work then you nee to go to power query anc change the path for each table.

kindly support my youtube channel https://www.youtube.com/@PowerBISolution