Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Resources Exceeded Error in Matrix Visual – Need Optimization Suggestions

Hi everyone,

I'm encountering a "Resources Exceeded" error in one of my Power BI reports. The issue happens when loading a matrix visual that includes multiple hierarchical levels (Level2 through Level6) along with a measure that calculates values using a DAX expression.

Some context:

  • Visual uses a matrix with fields: Particulars, Level2, Level3, Level4, Level5, and Level6 in rows.

  • Two measures are in the values section: Amount and Particular Amt Previous....

  • A filter is applied: Particulars is not blank.

  • Slicers are used for Organization and Period.

  • Data model contains large volumes of data from a financial dataset.

I've tried limiting slicers, but the issue persists. The goal is to preserve the drill-down levels but improve performance or avoid this resource cap.

Any suggestions on optimizing the measure or model structure to reduce resource usage would be highly appreciated.WhatsApp Image 2025-04-09 at 11.37.25.jpeg

2 ACCEPTED SOLUTIONS
HarishKM
Solution Sage
Solution Sage

@Anonymous Hey,

Check out this thread for some guidance: Re: The visual has exceeded the available resource... - Microsoft Fabric Community

 

Generally, whatever works is a good approach over that which does not work. Would really have to know more to say for sure 100% either way. You may be able to find another way by optimizing your DirectQuery queries but, again, hard to say.


Thanks

Harish M

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-pgoloju
Community Support
Community Support

Hi @Anonymous,

Just following up to check if the solution shared by our Super User helped resolve your issue. If you're still facing difficulties or need further assistance, please let us know — we’re here to help!

If the response addressed your query, we kindly request you to mark it as Accepted Solution and click Yes if you found it helpful. This supports others in the community as well.

 

Best regards,

Prasanna Kumar

View solution in original post

2 REPLIES 2
v-pgoloju
Community Support
Community Support

Hi @Anonymous,

Just following up to check if the solution shared by our Super User helped resolve your issue. If you're still facing difficulties or need further assistance, please let us know — we’re here to help!

If the response addressed your query, we kindly request you to mark it as Accepted Solution and click Yes if you found it helpful. This supports others in the community as well.

 

Best regards,

Prasanna Kumar

HarishKM
Solution Sage
Solution Sage

@Anonymous Hey,

Check out this thread for some guidance: Re: The visual has exceeded the available resource... - Microsoft Fabric Community

 

Generally, whatever works is a good approach over that which does not work. Would really have to know more to say for sure 100% either way. You may be able to find another way by optimizing your DirectQuery queries but, again, hard to say.


Thanks

Harish M

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.