cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 myname@domain.xyz)
  • 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: 

    https://youtu.be/Qb5EEjkHoLg (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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

4 REPLIES 4
Highlighted
Regular Visitor

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

Highlighted
Community Support
Community Support

Hi, @dawie 

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

https://docs.microsoft.com/en-us/analysis-services/instances/configure-the-windows-firewall-to-allow... 

Related thread:

https://community.powerbi.com/t5/Power-Query/Datasource-Creation-Failure-Attempting-to-Connect-to-a-... 

 

Best Regards,
Community Support Team _ Eason

Highlighted

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

Highlighted
Regular Visitor

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors