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

[john_elmasry]

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

[v-yanjiang-msft]

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]

Thank you for your reply.

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

Thanks