How do I analyze my DAX for "this visual has exceeded the available resources"?

[BZ_AF]

Hi There

I'm having some issues with some DAX measures which are causing the "Visual has exceeded available resources" panel, like this. In my case the memory on Power BI Service is exceeded.

Is there a way to analyze the size of the memory used for the dax calculation? The performance analyzer only shows the time to calculation, while DAX studio's Vertipaq Analyzer seems to analyze the end result memory of each step. Is there a way to see the total memory required for a calculation?

[Anonymous · Accepted solution]

Hi @BZ_AF ,

There seems to be such a feature in DAX Studio, it is the estimated size in memory (measured in KB) of the result of the storage engine query (this result is also called data cache). 
You can check it out according to this document:
New Server Timings features in DAX Studio 2.5.0 #dax #powerbi #ssas #tabular - SQLBI

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[olgad]

Hi, in almost all cases that I had this error message there was a problem with the relationships. Start taking the columns away from your table/matrix to see which column is causing it, where it comes from and what is the relationship with the source table. 

[BZ_AF]

Thanks for your input. The error message comes up sometimes and not always, so I am interested to see if we can diagnose the issue in a deeper detail so as to understand why. Still wondering if there is a way to analyze the overall memory required by the visualization.