Resources Exceeded Error in PowerBI

[prkumari]

I am running into the following error
The query has exceeded the available resources. Try filtering to decrease the amount of data requested.

Please check the technical details for more information. If you contact support, please provide these details.Underlying ErrorrsQueryMemoryLimitExceeded

More detailsResource Governing: This query uses more memory than the configured limit. The query  or calculations referenced by it might be too memory-intensive to run. Either simplify the query or its calculations, or if using Power BI Premium, you may reach out to your capacity administrator to see if they can increase the per-query memory limit. More details: consumed memory 10240 MB, memory limit 10240 MB. See https://go.microsoft.com/fwlink/?linkid=2159752 to learn more.

My setting is "Premium per user" the dashboard was working just fine until few days ago, following the recommendations online, I tried reducing the data set and it did not help. How do I increase the capacity to mitigate this issue?

[v-veshwara-msft]

Hi @prkumari ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[prkumari]

I have explored optimizing the queries and the page still fails with the same error. I have no visibility of what exact query is causing the issue, how to access the internal logs or contact the administrator to explore increasing the per-query memory limit option?

[v-veshwara-msft · Accepted solution]

Hi @prkumari ,

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.

[v-veshwara-msft]

Hi @prkumari ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.

[srlabhe]

The error is self explanatory 

To address this issue, consider the following actions:

• Filter the Data:

  • Apply filters to your visual or report to reduce the amount of data being displayed and processed. This is the most direct solution suggested by the error message.
• Optimize DAX Calculations:

  • Review and optimize any Data Analysis Expressions (DAX) used in your calculations. Inefficient DAX can consume significant memory.
  • Consider simplifying complex measures or breaking them down into smaller, more manageable parts.
• Reduce Data Granularity:

  • If dealing with highly granular data, especially datetime fields, consider reducing the level of detail. For example, instead of using full datetimes, separate dates and times into different columns or aggregate data to a higher level (e.g., by day, month, or year).
• Simplify the Visual:

  • If the issue is with a specific visual, try simplifying it by removing unnecessary columns, measures, or visual elements that contribute to high data volume.
• Optimize the Data Model:

  • Ensure your data model is efficient. Remove unnecessary columns or tables, optimize relationships, and consider using dataflows or pre-aggregation for very large datasets before loading them into your report.
• Increase Resources (if applicable):

  • If you are working within an environment with configurable resource limits (e.g., Power BI Premium capacity), you may need to contact your administrator to explore increasing the per-query memory limit or other resource allocations.
• Contact Support:

  • If the problem persists after trying the above steps, gather the technical details of the error and contact the support team for your specific platform (e.g., Microsoft Power BI support).