Forum Discussion
Microsoft SQL Server Analysis Services process killing my computer's memory
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.