Forum Discussion

Simon_W's avatar
Simon_W
Icon for Helper I rankHelper I
10 years ago

Error SSAS MD Connection on Server with Enterprise Edition depending on SSAS DB/ Cube

When I try to connect to SSAS MD cubes live via Power BI Desktop (Version: 2.36.4434.362 64-bit (Juni 2016)) on a SSAS Server 2012 sp3 cu4 Enterprise, it seems to depend on the Cube structure whether...
Simon_W's avatar
Simon_W
Icon for Helper I rankHelper I
10 years ago

 

XMLA and MDX works DAX doesn't with the  more complex cube [VerkaufsdatenControlling_SW]

 

On the same server with the Cube [ASTraceCube] MDX and DAX works.

 

Here is a screenshot from the Profiler with a simple DAX query an each Cube:

 

 

 

 

 

Best regards

 

Simon

Simon_W's avatar
Simon_W
Icon for Helper I rankHelper I
10 years ago

Any Update? The Problem still exists and I am pretty sure that it has to be connect to a certain SSAS MD feature we are using. Because as described some cubes work with Power BI Desktop and some don't on the same SSAS Server.