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!
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.