Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Change data source (Analysis service)

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 ca...
General Comment
Need Help
Tutorial Requests
GilbertQ's avatar
GilbertQ
Super User
3 years ago

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.