Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
5 months ago
Solved

Query has exceeded the available memory

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...
Need Help
tharunkumarRTK's avatar
tharunkumarRTK
Super User
4 months ago

 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-memory-limit

 

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