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
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.
Hi leonardmurphy, thanks for the information. I did attempt this, but received an error message that I do not have database access or the database doesn't exist. Both of these are not true - I can connect to the database in SSMS and Visual Studio, and am an admin in the Azure Portal as well as the Active Directory Admin on the Azure server.
It works fine when I import the data with the database left blank it works fine, but it defeats the purpose of hosting on Azure Analysis Services, imo.
It gives me the same error message when I import and fill in the database name. I am apart of the Madison Power BI User Group, so maybe we can discuss at the next Meetup if you're there.