Forum Discussion
Microsoft SQL Server Analysis Services process killing my computer's memory
Hello
Did you get any solution to this?
I am facing almost same problem where I want to know what this SSAS process is doing.
I have a DAX code to create a table basically using the UNION function in DAX, but it complains and gives memory issues.
Any inputs please?
Regards
Anonymous I've found joins (merges) and unions (appends) in PBI are significantly slower than just doing those actions in the queries themselves. I would recommend that you do as much of that type of work in your queries as possible, letting your server handle that, and let PBI do the dynamic aggregations, like measures.
Also, cut your data down to what you absolutely need; PBI, or the machine on which it's runinng, only has so much memory. That and make your measures as efficient as possible.
Hope this helps.
