Update data source connection for multiple reports (100+ reports)

[msft-cap]

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!

[Idrissshatila]

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-datasets

If 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-cap]

Hi @Idrissshatila - Thank you for your time. Are there any workarounds,  like leveraging Power Shell scripting or using parameters etc.?