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

I think u mean I should run a DAX query not a DMX query in SSMS right?

 

This gives me indeed the very same error as with Power BI Desktop

 

Error SSMS DAX

 

 

 

https://oraylis01-my.sharepoint.com/personal/s_winkelstraeter_oraylis_de/Documents/Public/DAX_SSMS_Error.JPG

 

The screenshot shows as well that the Cube from [ASTraceCube] works with DAX and [VerkaufsdatenControlling_SW] doesn't.

 

Further I would never the less not say that the cube from [VerkaufsdatenControlling_SW] is corrupt because all mdx/xmla access works.

 

Thanks for your support

 

Simon

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.