Matthias Schmid on 22 Nov 2016 18:21:52
I have a Live-Conneciton to a SSAS Multidimensional Database (Developing Scenario – for production we go over the Power BI Enterprise Gateway - there we have the same behavior).
When I’m creating a report/dashboard anything works fine. But when I try to create a Matrix or a Table in which several Dimensions (some of them are kind of hug dimensions) are involved, I run in a performance problem. The SSAS Server runs out of Memory (32 GB RAM). The Cube is not so big – so I think the 32 GB of RAM should be enough.
On a blog I found an interesting article where the same problem is described:
https://blog.crossjoin.co.uk/2016/09/26/ssas-multidimensional-caching-related-performance-problems-with-power-bi-tables/
At the moment I implemented the workaround to disable the total row and then anything works fine. But that’s not really satisfying for doing nice reports.