Forum Discussion

AngryKoala's avatar
AngryKoala
Frequent Visitor
11 years ago
Solved

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...
  • meysun's avatar
    meysun
    11 years ago

    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.

konstantinos's avatar
konstantinos
Memorable Member
11 years ago
Change the database in Navigation (2 step when in Edit Query) after connection
AngryKoala's avatar
AngryKoala
Frequent Visitor
11 years ago

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)

  • konstantinos's avatar
    konstantinos
    Memorable Member
    11 years ago

    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. 

    • meysun's avatar
      meysun
      Resolver IV
      11 years ago

      That's correct. Currently the product allows you to change only the server name using Edit Queries for AS live connection.