Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

cannot connect to analysis services with cube (SSAS - multidimensional), server: SQL Server 2014 SP1

I am trying to connect to a cube with Power BI Desktop. I get the following error message:   Based on the documentation (https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssa...
Dashboards
Gateways
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Anonymous

     

    It seems that you are connecting to multi-dimensional model on SQL Server 2014 Standard edition. In that case, it is not supported.

    As stated in this article, you need to have an Enterprise or Business Intelligence edition of SQL Server 2012/2014 Analysis Services, otherwise, you will get the above error message. 

    However, you are able connect to multi-dimensional models on SQL Server 2016 Standard edition from Power BI.

     

     

    Best Regards,
    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Anonymous

 

It seems that you are connecting to multi-dimensional model on SQL Server 2014 Standard edition. In that case, it is not supported.

As stated in this article, you need to have an Enterprise or Business Intelligence edition of SQL Server 2012/2014 Analysis Services, otherwise, you will get the above error message. 

However, you are able connect to multi-dimensional models on SQL Server 2016 Standard edition from Power BI.

 

 

Best Regards,
Herbert

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Okay. I see. Thanks for the feedback :-)