Mass Data Source Change

[Anonymous]

Hello Community,

I have a power bi report that reference a few excel files on my Teams sharepoint online site. I want to move these files to a new channel. Is there a painless way to change the reference of the data source at once?

Thank you!

[artemus]

Click on Data Source Settings. Then select your data source, and choose "Change Source...". Changing the source here will update all references to that data source.

[Anonymous]

The source URL is the same URL, so there's now "data source" change. However, in advance query editor it seems to reference a specific location in SharePoint. Is there a way to do a replace all to the queries...

[artemus]

Not really. If this is something that gets updated on multiple occasions, you can replace the file location string with a parameter with that value.