Forum Discussion
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...
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.
Thank you for your reply.
Is there anyway to change the connection Type from SSAS Cube to Online Published Power BI Dataset?
Thanks