Forum Discussion

jambrose's avatar
jambrose
Frequent Visitor
9 years ago

Improving Summarize Efficiency

I'm trying to pull information from a large (~20 mil records, 48 colmuns) table, and I have a working method, but it's on the verge of what my machine can handle, and so I'm worried it won't scale up...
Need Help
jambrose's avatar
jambrose
Frequent Visitor
9 years ago

I gave this a shot, and it didn't appear to make a significant difference in the memory load or execution time.  My understanding is that having it nested inside the SUMMARIZE implicitly filters in some similar manner anyway.  Or at least, the results I get (from either version) find the same value as desired - the top value out of only the rows with the given ID.  Thanks for taking a stab though!

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi jambrose,

The momery consumption is mainly by your large amount of resource table. While I guess memory load is not only caused by Power BI operation but also other threads in your local computer based on my understanding. Please check your computer's tasks and memory.

After search, there are some article about high performance Power BI and DAX, maybe it's helpful.

Optimizing DAX expressions involving multiple measures.
Performance Tip for Power BI; Enable Load Sucks Memory Up.
Power BI Performance Tips and Techniques

Best Regards,
Angelia