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
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
Icon for Power Participant rankPower 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