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...
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Simon_W

 

Sorry for my mistake, I mean "MDX", not DMX query.

 

I can't see your screenshot and URL returns 404. 

 

Is this [VerkaufsdatenControlling_SW] cube the "complex and bigger" one? You can query and execute XMLA against it properly?

 

Regards,

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
    9 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.