Connecting PowerBI (local) to SSAS (Azure)

[juanvg1972]

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.

[v-yuezhe-msft]

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]

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

[v-yuezhe-msft · Accepted solution]

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-loca...

Thanks,
Lydia Zhang

[juanvg1972]

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