Forum Discussion
Can't connect to SQL Server 2016 SSAS Tabular Model on local network server from Power BI Desktop
Have you tried typing in the Database (cube) name? The field shows as optional, but I have one instance where, if I leave it blank, it won't find any cubes, but if I fill it in, it works just fine.
Thank you leonardmurphy! That did the trick for me.
So in summary here are the two things I needed to do.
1. Run PowerBI Desktop from the command line under the context of the remote user.
2. Enter the database (cube) name (even though it says it's optional)
Thanks to all who helped with this!
Douga
Hi all,
Seeking urgent help!
I am facing simillar problem but in my case, I am trying to connect Power BI desktop(on my laptop) to SSAS tabular(On -premise server) within my office network. I am getting follwing error
Details: "AnalysisServices: A connection cannot be made. Ensure that the server is running."
Whereas, I can connect to SQL Database on same server using SSMS. Can you Please advice
Q1, Can I connect Power BI desktop(my laptop) to SSAS tabular server(On-Premise server) using my office network?
Q2, As SSAS uses windows authentication, do I need to create any hybrid authentication method ?
Please advice
mazharmh,
Your Windows Authentication username has to have the appropriate security access to the SSAS instance.
I've found that you need to enter the SSAS database name even though it says on the dialog that the name is optional.