Forum Discussion

juanvg1972's avatar
juanvg1972
New Member
9 years ago
Solved

Connecting PowerBI (local) to SSAS (Azure)

Hi, I want to try to connect to a SSAS cube from PowerBI Desktop . My SSAS cube is in a azure machine and Powerbi desktop is in my local Pc. I know the name of the server, the database and I have cre...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi juanvg1972,

    Are your Power BI Desktop and  SSAS server in same domain? If not, you would get error message during connection process. Please  use runas /netonly command as follows to connect to SSAS from Power BI Desktop and check if it is successful.

    1. Open command prompt and run the following command, enter the password of domain user when prompted.
    runas /netonly /user: Domain\username "C:\Program Files\Microsoft Power BI Desktop\bin\PBIDesktop.exe"

    2. Create a saved windows credential for the SQL Server you want to connect to.

    There is a similar thread for your reference.
    https://community.powerbi.com/t5/Desktop/Can-t-connect-to-SQL-Server-2016-SSAS-Tabular-Model-on-local/td-p/99438

    Thanks,
    Lydia Zhang

juanvg1972's avatar
juanvg1972
New Member
9 years ago

Hi Lydia Zhang,

 

Thanks for your help. I attach the error screen.

 

I have tried both "Import" and "Connect Live". When I use "Connect Live" the error is "server not found".

When I use "Import" I have tried all options  and it doesn't connect in any option.

The azure server is running.  I know the server name and credentials are correct because I use it from Excel (not PowerBI) and it works well and also are the credentials I use in azure to connect to SSAS.

I have tried DNS name and IP, I have tried also dnsname/instance and nothing works

When I try to connect to a SQL Server relational database (not SSAS) it works well from PowerBI in the same Azure. ¿¿??

Its very stange this error, I don't know what to try. It's important to me to solve this error, If I can connect from

PowerBI I have to turn to another tool. 

Thanks in advance

 

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi juanvg1972,

Are your Power BI Desktop and  SSAS server in same domain? If not, you would get error message during connection process. Please  use runas /netonly command as follows to connect to SSAS from Power BI Desktop and check if it is successful.

1. Open command prompt and run the following command, enter the password of domain user when prompted.
runas /netonly /user: Domain\username "C:\Program Files\Microsoft Power BI Desktop\bin\PBIDesktop.exe"

2. Create a saved windows credential for the SQL Server you want to connect to.

There is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/Can-t-connect-to-SQL-Server-2016-SSAS-Tabular-Model-on-local/td-p/99438

Thanks,
Lydia Zhang

  • juanvg1972's avatar
    juanvg1972
    New Member
    9 years ago

    Using runas command works well....thanks Lydia!!