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
Highlighted
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
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Kudoed Authors (Last 30 Days)