Query has exceeded the available memory

[stribor45]

Is there a way to fix this so my visual shows up. Sometimes it works fine and sometimes I get this error on my Desktop Power BI. This same report is published in service and dont have this issues. Is there a way to fix this on my desktop

Thank you

[cengizhanarslan]

I would first check File → Options and settings → Options → Report settings → Query limit simulations and either set it to No query limits for testing, or match it to the capacity/workspace where the report is published. The accepted reply on that thread also points to this exact setting as the likely cause.  If it still fails after that, then the issue is more likely the visual itself being too heavy on your machine, for example too much granularity in the visual, expensive measures, or just limited local RAM. In that case, the fix is to reduce the data shown at once and/or optimize the DAX and model.

[tharunkumarRTK · Accepted solution]

 This is because "Query limit simulation" settings in power bi desktop.

Power BI desktop by default applies 1GB as memory limit and 255 seconds as timeout limit. These settings can be changed under "Report settings" in "Options & settings" menu. You can either set it to custom or no limits. 

 

 

You can read more about this setting in this page

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-set-visual-query-limits 

Where as in service limits depends on your Workspace Type. If it is Pro workspace then the limit is 1gb and if it is hosted in a fabric capacity then it depends on the capacity SKU type, refer this page for more details

https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/service-admin-premium-workloads#query-me...

I recommend you to set the query simulation limits in desktop according to your power bi service/fabric workspace type. So that you can simulate your report with in the same limts as service.

Hope this helps

You can read my aritcles here: https://www.techietips.co.in/

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

@stribor45

[danextian]

hi @stribor45 

This can occur when the device doesn’t have sufficient memory to render the visual. Typically, Power BI Desktop does not throw an error in this situation, but the Power BI Service may—unless the report is hosted in a workspace with dedicated capacity and there are enough resources available at query time to render the visual successfully—or simply because too many applications on the device are competing for the same resources. Try reducing the number of concurrent desktop apps. If that doesn't work and the workspace doesn't have a dedicated capacity, it will come down to reducing the granularity in the visual and/or optimizing the measures involved.