Change data source (Analysis service)

[Anonymous]

In my workspace I have more than 5 reports and these reports are connected with analysis service.
I want to change data source analysis service with another Analysis service.
Is there anyway, we can change data source of all reports using script instead of open each report and change data source?

[Anonymous]

I have more than 90 reports in my workspace. Is there any way (script) for update data source of Analysis service?
@GilbertQ 

[GilbertQ]

You could look at PBI-Tools which might be able to do this

[GilbertQ]

Hi @Anonymous 

One thing to note is that when you change the data source to your report it is also going to create a new report in the Power BI Service.

What I mean by this is if you have a current report names "Sales" connecting to an AAS called "Server1" and you open the Sales report and change the AAs to "Server2" when you upload it to the Power BI Service you will have 2 reports called "Sales"

This is by design when ever a data source is changed it created a new underlying report GUID.

I had this issue for a customer and fortuntely we were using Apps, so it was not a big issue because the report names remained the same. And I actually just opened each report and changed the source to make 100% sure that each report did not have any issues.