Forum Discussion
Query has exceeded the available memory
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
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!
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.