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
Anonymous, I am also having this same issue. I am able to import data from the model, but am not able to connect live to the data source.
I am using Azure Analysis Services and created a SSAS 2016 Tabular Model with AdventureWorks2012. I can connect with no issues in Excel 2013. When I attempt to Connect Live I recieve the following error message:
Sorry, the server you're trying to connect to doesn't have any models.
However, when I attempt to Import, I then have no problems connecting to the data source.
Any idea on how I can resolve the Connect Live error message? I cleared the Global Permissions and also reinstalled Power BI Desktop, but still wasn't able to connect.
Thank you,
Michael
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
In Visual Studio, where you deployed your SSAS database, go to Cube Structure > Properties > Visible setting set to True
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.