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.
lbendlin
on:
Fabric Copy Activity Upsert Needs Native Audit Col...
on:
Power BI Subscriptions enhancements sorely needed
on:
Ragged Hierarchy Display options in Matrix Visual
miguel
on:
Personalized Source List in Get Data