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

lcampos's avatar
lcampos
Frequent Visitor
9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

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

    • 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