Forum Discussion
Update data source connection for multiple reports (100+ reports)
Hi All
We have 100+ reports pointing to around 10 AAS models in total. I need to change the data source (AAS server name) on these reports. Is there a way to change the data source efficiently rather than opening each report and then change the source?
These reports do not use dataset also, each report has their own AAS server connection.
Appreciate any insights on this!
2 Replies
- IdrissshatilaSuper User
Hello msft-cap ,
Unfortunately, you Should open each report and change the name.
For next time, create a Connect them all to a Power BI Dataset, so that they all read from one data file
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasetsIf I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡- msft-capHelper II
Hi Idrissshatila - Thank you for your time. Are there any workarounds, like leveraging Power Shell scripting or using parameters etc.?