Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
billzhang1123
Helper II
Helper II

PBI Desktop can't connect to remote SSAS

We have a SSAS Server on which PBI Desktop is also installed. Connect from PBI Desktop to the local SSAS is fine.

But remote PBI Desktops can't connect with the same error: "we could not connect to analysis services server because the connection timed out or server name is incorrect". However port 2383 is accessible from these remote VMs. firewalls on these VMs are turned off. any other reasons?

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

Hi @billzhang1123,

How do you connect to the remote SSAS server from Power BI Desktop? Via “import” option or “Connect Live” option? Also please tell us what is the version of the SSAS version and check if you can successfully connect to it from Excel?

Besides, does the Power BI Desktop and remote SSAS server exist in same domain?


Thanks,

Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

i will get the answers for you. However I know these two VMs are not on the same domain. is this the problem?


@billzhang1123 wrote:

i will get the answers for you. However I know these two VMs are not on the same domain. is this the problem?


Hi @billzhang1123,

Yes.

I cannot reproduce you issue when connecting to remote SSAS database from the latest version of Power BI Desktop when the machine running SQL Server and the PC running Power BI Desktop are in same domain.

 

In your scenario, as  SQL Server  and Power BI Desktop don’t exist in a same domain, 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. 

For more details, please check the following similar blog and similar thread.

Pretend You’re On The Domain With Runas /NetOnly
Connecting PBID to SSAS Tabular when not in domain

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.