cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mtassin
New Member

DAX Query generation against MDX cube resulting in terrible performance

We've got an MDX Cube with about 10 billion rows, partitioned into 1 month blocks of about 20 million rows.

 

What we've noticed though is a query generated via Excel vastly outperforms the same desired results generated out of Power BI Desktop (Report server edition).  The only thing we can surmise is that the DAX query is just less efficient than the MDX query for the same result set.

 

Seeing as Excel has a fairly decent (not perfect) MDX query generator, why doesn't Power BI borrow that for MDX cubes instead of the translation of DAX to MDX that's apparnetly murdering our performance?

 

Is there a way to get Power BI to generate MDX queries instead?

1 REPLY 1
Anonymous
Not applicable

Can you explain how can you use 20billion rows? We struggle when we try to import even less than 1million from BW. What kind of database source are you using?

I would really appreciate it to understand if we are doing the wrong approach.

 

Thanks! 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors