topic Re: How do I analyze my DAX for "this visual has exceeded the available resources"? in DAX Commands and Tips

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

Anonymous — Mon, 15 Jan 2024 06:53:11 GMT

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?

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

olgad — Mon, 15 Jan 2024 08:18:27 GMT

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.

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

Anonymous — Mon, 15 Jan 2024 09:13:15 GMT

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.

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

Anonymous — Wed, 24 Jan 2024 09:44:15 GMT

Hi Anonymous ,

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