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 credentials, but connection return an error. I don't understand, because the same connection string in an Excel (not PowerBI) works well.

How can I have to connect from PowerBI?

Any advice will be greatly appreciated.

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi juanvg1972,

    Do you connect to SSAS on Azure VM? If so, do you use “Import” or ”Connect Live” mode in Power BI Desktop? And please help to post the full error message.

    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