Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
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...
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.