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 can change data source of all reports using script instead of open each report and change data source?

General Comment
Need Help
Tutorial Requests

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

    • GilbertQ's avatar
      GilbertQ
      Super User
      3 years ago

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

  • 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.