Forum Discussion

john_elmasry's avatar
john_elmasry
Frequent Visitor
3 years ago

Change Data source to different SSAS DB and Cube in Direct Query Mode

Hello Everyone,

I have dashboards built with a live connection to Sql Server Analysis Services, Now I want to change the data source of these dashboards to point to another SSAS Server and cube that I built with the same structure as the main one.

How can I achieve that?

Thank you

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi john_elmasry ,

    Please try the following steps:

    • Open your Power BI Desktop file that contains the dashboards and the live connection to SSAS.
    • Go to File > Options and settings > Data source settings.
    • Select the data source that you want to change and click Change Source.
    • Enter the new server name and database name for your SSAS data source and click OK.
    • Click Close and then click Apply Changes on the yellow ribbon bar.
    • Save your Power BI Desktop file and publish it to the Power BI service.
    • In the Power BI service, go to Settings > Manage gateways and select the gateway that you use for the live connection to SSAS.
    • Click Add data source and fill in the information for the new SSAS data source. Make sure the data source name matches the one in your Power BI Desktop file.
    • Click Add and then close the window.

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • john_elmasry's avatar
      john_elmasry
      Frequent Visitor
      3 years ago

      Thank you for your reply.

       

      Is there anyway to change the connection Type from SSAS Cube to Online Published Power BI Dataset?

       

      Thanks