Forum Discussion
"Resources exceeded" error message
Hello, I get the error that I attached in this post, does anyone know how to solve it? Thank you
Hello Valen ,
is seems that you're putting a huge dataset in a table, you need to apply some filters or do some aggregations.
Hi Valen ,
The “Resources exceeded” error message in Power BI typically indicates that a query or the calculations it involves are consuming more memory than the configured limit. This issue can occur when a visual has attempted to query too much data. Here are some tips to resolve this issue:
- Filter the visual: Try filtering the visual to reduce the amount of data in the result.Solved: Service: Visual has exceeded available resources. ... - Microsoft Fabric Community
- Optimize your DAX calculations: Inefficient DAX calculations can cause a query to use a lot of memory. Optimizing these calculations can help them use less memory and return faster.
- Remove unnecessary precision or split granularity values: This can help to reduce cardinality.
- Do not expose unnecessary columns: Avoid exposing in a view a column that is not necessary in the Power BI data model.
Optimization guide for Power BI
For DAX:
Use Performance Analyzer to examine report element performance (can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.)
Best Regards
3 Replies
Hello Valen ,
is seems that you're putting a huge dataset in a table, you need to apply some filters or do some aggregations.
Thanks! I'll try what you told me
Hi Valen ,
The “Resources exceeded” error message in Power BI typically indicates that a query or the calculations it involves are consuming more memory than the configured limit. This issue can occur when a visual has attempted to query too much data. Here are some tips to resolve this issue:
- Filter the visual: Try filtering the visual to reduce the amount of data in the result.Solved: Service: Visual has exceeded available resources. ... - Microsoft Fabric Community
- Optimize your DAX calculations: Inefficient DAX calculations can cause a query to use a lot of memory. Optimizing these calculations can help them use less memory and return faster.
- Remove unnecessary precision or split granularity values: This can help to reduce cardinality.
- Do not expose unnecessary columns: Avoid exposing in a view a column that is not necessary in the Power BI data model.
Optimization guide for Power BI
For DAX:
Use Performance Analyzer to examine report element performance (can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.)
Best Regards
