Forum Discussion
Unable to connect to SSAS Live mode
Hi,
When i choose to live connect to SSAS Tabular, i have this message :
"Sorry, the server you're trying to connect to doesn't have any tabular models."
but if i choose to import data with the same connection, that works.
Help me please.
15 Replies
Hi, the user that you're using to connect from the portal has permissions on the cubes?, SSAS tabular use windows integrated authentication.
Regards
Hi,
Thanks for answer, but i'm not on the portal, i'm using PowerBI Desktop on my computer and i have all permissions on the Tabular database.
That works when i choose import data from the tabular database but when i choose live connection i have the message.
Regards
Review the following docs:
Configure an SSAS connector
and
Troubleshoot a SSAS connector
https://support.powerbi.com/knowledgebase/articles/505324-troubleshooting-analysis-service-connector
Import works for both Multidimensional model as well as tabular model. Explore live is currently suppored only in tabular models. So check to see if you have Multidimensional or Tabular.
To connect from the Power BI desktop, you don't need to install th AS connector. But if you are going to publish this report to the Power BI service, then you need AS Connector.
I'm sure i use a tabular model, i use Power bi Desktop, my database is SQL Server 2012, i have all permission all works on my computer but not the live connection in power bi Desktop.
Are you trying to connect to a Tabular or a Multidimensional instance of Analysis Services? I believe only Tabular instance is supported for direct connect from Desktop.
- Make sure your model also has a use setup as a role on it.
Hi
Im am getting the same problem - with no solution so far.
I have a Multidimensional Cube that does not connect via AS.
Quick questions;
#1
If I follwed this thread correctly, then only Tablular Models will work this way, right?
#2
I am planning to use Power BI, on-premise only.
Is this (Tabular Data Models via ) the only wat i can acces and publish data to PowerBI Desktop / Server?
Kind Regards
