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

 

When connecting SSAS in Power BI Desktop, even some features is not supported in current release, it just means those features/settings will not be enabled/loaded into Power BI, but you should still be able to connect SSAS database properly. In your provided trace log, it shows error on when executing "Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet" function.

Please connect this SSAS database in SSMS, and execute some MDX against it to see if there's any corruption on this "complex" cube.

 

Regards,

  • 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