Forum Discussion
Microsoft SQL Server Analysis Services process killing my computer's memory
v-chuncz-msft I forgot to mention, now updated in the OP, that I haven't pulled the data for this report in some time; there should be nothing query-related going on. I'm merely messing with some measures and visuals.
Any update on this?
I'm getting memory error issues when trying to create new measures.
Under Power BI desktop SSAS is taking up nearly half of the memory, and there are also about 12 instances of Microsft Mashup Evaluation Container
No. I started over and used some other methods to create the report that I wanted. Still doesn't explain what was going on.
Still no update on this one? I am experiencing the same issue, but nothing seems to be an easily identifiable culprit.
JRHans09 Nope. I've mentioned it to several Microsoft support folks. I don't think anyone there knows how those three processes work. Maybe the original devs.
The only solution that I know of is to write your measures smarter; use more efficient code. Learn to use variables, switch statements, the differnces between filtering tables and calculatetables.
The key thing is that EVERY TIME you name a measure, field, or table, PBI calls, and calculates, it again! A simplistic example would be if you wanted to cube a number:
Cube = [number] * [number] * [number]
This code calls [number] three times! This would be slower than:
Cube = VAR num = [number]
RETURN num * num * numWhich only calls it once.
For more, check out my other thread: https://community.powerbi.com/t5/Desktop/Slow-Measures/m-p/440978
And there are a few others like this out there.