PowerBI Pro connection to SSAS on premise fails

[Anonymous]

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!

[v-easonf-msft]

Hi, @Anonymous 

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-analysis-services-access?view=asallproducts-allversions 

Related thread:

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

Best Regards,
Community Support Team _ Eason

[Anonymous]

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

[Anonymous · Accepted solution]

Hi All

I fixed it following this:

https://community.powerbi.com/t5/Service/quot-This-report-couldn-t-access-the-datasource-quot-SSAS/m...

i.e. run SSAS service as domain account.

[Anonymous]

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