Forum Discussion

Frequent Visitor

8 years ago

Solved

Problem Connect to SSAS Multidimensional Models in Power BI Desktop

I am trying to connect an olap cube MD by means of the live connection of Power BI desktop and it reports me the following error.

I'm using Microsoft SQL Server Analysis Services Versión 11.0.3000.0

and Power BI Desktop Version: 2.58.5103.501 64-bit (mayo de 2018)

The import mode works correctly.

Any idea?

Anonymous
8 years ago
Jsevilla4,

Servers must be running SQL Server 2012 SP1 CU4 or later versions of Analysis Services when you use live mode in Power BI Desktop to connetc to SSAS MD.

In your scenario, you can apply latest version of service pack for SQL Server 2012

Regards,
Lydia

3 Replies

Anonymous
Not applicable
8 years ago
Jsevilla4,

Servers must be running SQL Server 2012 SP1 CU4 or later versions of Analysis Services when you use live mode in Power BI Desktop to connetc to SSAS MD.

In your scenario, you can apply latest version of service pack for SQL Server 2012

Regards,
Lydia
- Jsevilla4
  Frequent Visitor
  8 years ago
  Thanks, my version of SSAS is 11.0.7001.0 (SQL Server 2012 SP4) and the problem continues.
  
  When I use a cube in SQL 2008 the error is different.
  
  I suppose the error is not version database engine,
  
  thanks again.
- Jsevilla4
  Frequent Visitor
  8 years ago
  Fixed with the update of the SQL Server 2016 version.