Forum Discussion
Changing Connection in SSAS Live mode
In Power BI Desktop (or in the portal for that matter) how do I change to connect to different SSAS Tabular Database ?
eg Just want to change the connectin string...
With the latest update of Power BI Desktop, you can change both the server name and the database/cube name from the "Edit Queries" button when you connect to AS in explore live mode.
13 Replies
Hi,
I think the solution for Desktop is here (at the bottom) :
Click on Edit Query, here you can change the connection for the AS server.
Thanks Kasper, but actually is *same* server just different SSAS Tabular database.
(in fact is same database, it was just renamed)BTW: My client rebuilt all her dashboards, published and had everything running in the portal in one morning
KUDOS TO THE TEAM
- Change the database in Navigation (2 step when in Edit Query) after connection
Appreciate you taking time to answer, *but* there is no second step - it fails on the first.... see screenshot above
Easy to reproduce
1. Connect to SSAS Server
2. Select database
3. Select model (cube)
4. Back on server, rename database
5. Back in Power BI Desktop now have error
6. Click on Edit - can't get past dialog (see above)
There is no screenshot, but you are right, my mistake. When you edit the query ( as live ssas connection ) you cannot see M in order to change the query neither shows up in data sources. Maybe the team can change and give as the UI to enter advanced editor.
AngryKoala konstantinos meysun kdejonge Thib You can try the following step to delete any existing connection (instead of using edit queries) and to connect to same server but different database or same database
Let me know if this works! Thanks
NO
Followed instructions and deleted datasource
- Deleted connection "localhost\tabular"
- Closed PBID file
- Opened PBID file
- just have "spinny" (obviously as connection gone)
- clicked Edit Queries
- entered "localhost\tabular"
- clicked OK
- get same error in "!" error and when click get following in yellow box
"Either the user, galah\Grant, does not have access to the zzHyProfit database, or the database does not exist."
Any other suggestions?
With the latest update of Power BI Desktop, you can change both the server name and the database/cube name from the "Edit Queries" button when you connect to AS in explore live mode.
