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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Not applicable

PowerBI Pro connection to SSAS on premise fails

Hi guys


I am getting this error:


The connection to the Analysis Services instance timed out or was lost. Ensure that the server and the 'SQL Browser' service are running.



I have tried:

  • Confirmed that SQL browser is running on the VM where I want to connect to
  • Local Active Directory - Joined the VM from where SSAS is hosted on the domain which is the same as Azure AD
  • Opened ports on VM for SQL browser and SSAS
  • Gave SSAS a dedicated port on the VM to ensure it is not dynamically changing fwiw
  • Made SQL brower service log in using my domain account instead of default service account
  • Mapped Users on PowerBI service connection setting under the gateway settings to ensure efective username = DOMAIN\Username (confirmed in gateway logs that the name is pulling throug and not in format
  • even tried opening ports on the router temporaritly although that should not be required since normal SQL connections seem to work
  • I have specifically seen this video from Guy in a Cube: (Authentication with AS live connections in Power BI)

I feel like I am runnig around chasing my tail.  What other checks could I have missed?


Thanks guys!

Not applicable

Community Support
Community Support

Hi, @Anonymous 

Please make sure that you have configured the windows Firewall to allow analysis Services Access. 

Related thread: 


Best Regards,
Community Support Team _ Eason

Not applicable

Hi guys

Yes, I have opened the firewall ports for SSAS and SQL and I have tested connectivity using SSMS from another VM and it works fine.

Unfortunately no luck on PowerBI service side still

Not applicable

Hi All


I fixed it following this:


i.e. run SSAS service as domain account.


Not applicable

Oh yes, and DOMAIN\Username is added as an Administrator role on the SSAS side

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


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.

Top Solution Authors
Top Kudoed Authors