Forum Discussion

craig_wilson's avatar
craig_wilson
Frequent Visitor
10 years ago

SASS Mutidimensional import Extremely slow

Hi All,   I am connecting to a Multimdimensioal SSAS cube from within Power BI desktop and I am attempting to import a single column from 3 dimensions, one of them is the date dimension, and a sing...
Need Help
gooranga1's avatar
gooranga1
Power Participant
10 years ago

Ah, are you running power bi with the May update? If you are there is a bug that means you can't post mdx into a data source. Very very annoying which is why we won't upgrade until it's fixed. Looks like the when power bi translates from dax to mdx it turns it into a bit of a mess, well that is what I am guessing it does.

 

 

https://community.powerbi.com/t5/Desktop/MDX-script-not-being-recognised-in-new-version-of-power-bi/m-p/40636#M15278

 

https://ideas.powerbi.com/forums/360879-issues/suggestions/14743518-power-bi-desktop-may-update-import-data-from-ssa

craig_wilson's avatar
craig_wilson
Frequent Visitor
10 years ago

We are not wanting to post MDX into PowerBI, the users don't know MDX. They want to use Power Query to pull in the fields from the cube they want e.g. import the data. The MDX above was captured from SQL Server Profiler.

 

I agree the DAX to MDX looks awful and performs terribly. MS need to fix this.

  • gooranga1's avatar
    gooranga1
    Power Participant
    10 years ago

    okay I see.

     

    I suppose the alternative is to re-create your cubes but in a tabular model instead of multi-dimensional.

    • craig_wilson's avatar
      craig_wilson
      Frequent Visitor
      10 years ago

      Porting to Tabular is not an option for us unfortunately