cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mtassin Frequent Visitor
Frequent Visitor

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
PabloMaldonado Regular Visitor
Regular Visitor

Re: DAX Query generation against MDX cube resulting in terrible performance

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!