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.

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
Resolver 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
    Microsoft 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?

     

     

     

    • cmn's avatar
      cmn
      Kudo Collector
      10 years ago

      I also need to know if this is possible.  Due to network/security issues, I am only able to develop dashboards using the power bi web site.  We currently only have a dev database (SSAS), so I would like to develop reports pointing to that, and then switch to a production database when it is ready.

       

      Is this possible?