Resources Exceeded Error in Matrix Visual – Need Optimization Suggestions

[Anonymous]

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.

[HarishKM · Accepted solution]

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

[Anonymous · Accepted solution]

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 · Accepted solution]

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