I have a multidimensional molap cube with 15 measures and ~15 dimensions. The cube is browsed from POWER BI service, and the SSAS server use an "on premises data gateway" with the memory of 24GB. When I browse a table visualization report with value contains of 1 measure and 3 attributes from different dimensions, the result seems good that I can have the report appeared. But when I try to add more (another) attributes, the report just keep loading (loading forever) and the memory in the ssas server is used until exhausted. Please advise what should I do when I face that issue?
Note : I have tried to browse the SSAS with the same measures and dimensions in SSMS the report is appeared. I saw 2 DAX query from power bi when I did profiling on SSAS. The first query got error “The operation has been cancelled because there is not enough memory available for the application..”
