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.

ashishrj's avatar
ashishrj
Icon for Power Participant rankPower Participant
11 years ago

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

 

solution.png

 

Let me know if this works! Thanks

  • AngryKoala's avatar
    AngryKoala
    Frequent Visitor
    11 years ago

    NO

     

    Followed instructions and deleted datasource

    1. Deleted connection "localhost\tabular"
    2. Closed PBID file
    3. Opened PBID file
    4. just have "spinny" (obviously as connection gone)
    5. clicked Edit Queries
    6. entered "localhost\tabular"
    7. clicked OK
    8. 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?

     

    • meysun's avatar
      meysun
      Icon for Resolver IV rankResolver IV
      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.

      • GerryFlanagan's avatar
        GerryFlanagan
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        Hi Meysun,

         

        Can you tell me if there is any way of changing the SSAS connection if the report was built in the cloud based service?