Resources Exceeded Error in PowerBI

Hi Anonymous ,

Thanks for reaching out to Microsoft Fabric Community.

In Power BI Premium Per User (PPU), the per-query memory limit is fixed at 10 GB and cannot be increased. Unlike Premium capacity, PPU does not provide a way to configure or raise this limit, even for workspace or tenant admins.

Reference: Re: 10240 MB query memory limit - Premium Per User... - Microsoft Fabric Community

The error you are seeing occurs when a visual or calculation exceeds this memory limit. There isn’t a way to see exactly which internal query is consuming the memory in the service, but you can use Performance Analyzer in Power BI Desktop to identify visuals or DAX measures that are most resource-intensive.

In Desktop, you can also temporarily turn off query limits under File -> Options -> Report settings -> Query limit simulations to capture the DAX query causing the error. This is helpful for diagnosing which part of your report is memory-heavy, but these settings only affect Desktop and do not change the fixed 10 GB limit in PPU.

Power BI May 2023 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

To resolve the issue, the model, DAX calculations, or visuals need to be optimized. Updating your dataset to use a star schema can make the model more efficient and better suited to the Power BI engine. Measures can be adjusted to reference dimension tables instead of large fact tables, reducing memory required for queries. Splitting large tables, aggregating data, filtering unnecessary rows, or simplifying complex measures can further help.

If after optimization the error persists, the only option to get higher per-query memory is to move the report to a Premium capacity workspace, where per-query memory limits are configurable.

Here are some similar discussions: Solved: Query Resources Exceeded Error - Microsoft Fabric Community
Solved: Resources Exceeded This visual has exceeded the av... - Microsoft Fabric Community

Thanks srlabhe for sharing valuable optimization steps.

Hope this helps. Please reach out for further assistance.

Thank you.