Forum Discussion

lcampos's avatar
lcampos
Frequent Visitor
9 years ago
Solved

Connect Live SSAS MD

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
lcampos
Frequent Visitor
9 years ago

Hi Anonymous!
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