Connect Live SSAS MD

[lcampos]

Hi All.

I'm trying to connect to a SSAS MD instance in Power BI desktop, but when i input the server name and select the "Connect Live" option and hit the OK, the opion is automatically changed to "Import Data" (It's like i can't use the connect live option).

Is there any limitation to connect to SSAS MD with power BI?

I'm running SQL Server 2014 Standard Edition and SSAS.

Thanks

[Seth_C_Bauer]

@lcampos Have you already connected to a different data source in which you imported data, or is this the only connection you are trying to make within the PBIX file?

[lcampos]

Hi @Seth_C_Bauer.
Thanks for your repply.

Unfortunately no.

This is my first time using the Power BI and i'm trying to create an example to my manager showing the funcionalities that i'm learning/searching on the internet.

We already have a SSAS Cube deployed with some measures and dimensions and i'm trying to connect into it with the power BI, but the only option that i  can use is the Import

[Seth_C_Bauer]

@lcampos Have you checked the limitations section on this site about the connection to SSAS MD? Are you using a feature in the MD cube that isn't supported, and thus Power BI is defaulting to import as a result?

[lcampos]

Hi @Seth_C_Bauer
I've checked the limitations and it seems that the cubes are fine.
It's just a simple cube (not partitioned, without actions or named sets).
The server has 3 databases and the import it's been selected before I specify the database or cube.
I'll try to upgrade the SQL Server (SP and maybe the version).

Thanks again!

[v-yuezhe-msft · Accepted solution]

Hi @lcampos,

I can reproduce your issue when connecting to Standard edition of SSAS 2014 Multidimensional instance via “Connect live” option in Power BI desktop. However, it is successful when I connect to SSAS 2014 Enterprise MD instance via “Connect live” option in Power BI desktop.

As stated in this blog, it requires an Enterprise or Business Intelligence edition of SQL Server Analysis Services when you connect to SSAS 2012 CU4 (or SSAS 2014) MD instance from Desktop using live connection option. In the previous version of Power BI desktop, you will get the message which looks like below when connecting live Power BI Desktop to a Standard edition of SSAS MD instance. In the latest version of Desktop, it automatically changes “Connect live” to "Import Data" rather than throwing error message based on my test.

“Errors related to feature availability and configuration: The ‘Tabular View’ feature is not included in the ’64 Bit Standard’ edition of Analysis Services.”

In addition, based on charles’s response in this idea, connecting Power BI to MD models works for SQL Server 2016 Standard edition. You should be able to connect to SSAS 2016 Standard MD instance from Desktop using “Connect live”option.
 
Thanks,
Lydia Zhang

[lcampos]

Hi @v-yuezhe-msft!
Ow..that's great news.

I've installed the SP2 on SQL Server / SSAS Std Edition and the problem was still there

But  the links that you provide were very helpful (Thanks a lot!!)
I'll deploy the cubes on the SQL Server 2014 Enterprise edition to test .

About the error message: I prefer the error message provider in previous version (I've found a ScreenShot on the google with the error message) 🙂

Again..Thank you all for the Help.

Luiz