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
Hello,
I've got a SQL Server 2016 SSAS Tabular Model instance up and running on a customer's local network server. I VPN into the customers network to access their network and the SQL server with the SSAS instance.
I'm trying to connect to that SSAS Model from my local desktop PC (Windows 10) using Power BI Desktop (just downloaded the most recent version). I have not been successful so far.
(Note that I can successfully connect to this Tabular Model from Excel, from this same PC, using Power Pivot.)
If I try to connect to the server using Get Data/Analysis Services, enter the server name and select "Connect Live" and click OK, I get the message "We could not connect to the Analysis Services server because the connection times out or the server name is incorrect."
If I try to connect using the Import Option and enter my Windows Credentials (AD credentials for the customer's network - same as when connecting via Excel) I receive the message "The user was not authorized".
I've seen a number of requests about this issue, but no clear answers. If this can be done and someone has a clear step-by-step procedure or reference on how to do this, I'd sure like to see it.
Thanks for any help anyone can provide!