Forum Discussion

SivaMani's avatar
SivaMani
Resident Rockstar
8 years ago
Solved

SSAS Live - How to change the source(server)?

Hi Team,

 

I've used SSAS Live connection in my report. Now I want to change the SSAS server Let's say from DEV to QA.

 

Is there any way to change it?

 

Kindly help me!

Need Help
Tips and Tricks
  • SivaMani's avatar
    SivaMani
    8 years ago

    It's working perfectly fine. I did restart the Power BI Desktop after switching the server.

     

    Thank you!

8 Replies

  • sdjensen's avatar
    sdjensen
    Solution Sage
    8 years ago

    If you have build you report in a Power BI Desktop with a live connection to you Analysis Services cube, you can change the connection by opening the file and then in the "Edit Queries" drop-down list you can select "Data source settings" and here you can change the connection to another cube.

    • SivaMani's avatar
      SivaMani
      Resident Rockstar
      8 years ago

      sdjensen,

       

      Thanks for the reply.

       

      I wanted to change the server. Both the server has same database. 

       

      FYI - I've tried the option. But It doesn't work.

      • sdjensen's avatar
        sdjensen
        Solution Sage
        8 years ago

        Guess you didn't do it right then. I just did a test where I created a new .pbix file with a live connection to my test cube on server1 and then changed the connection to my live cube on server2.