Visual exceeded the available resources matrix visual

[Neha_12]

Hi,
I have a matrix visual, with 4 rows as drill down levels and 8 to 10 fields as values.
there is a filter for item, which is a part of matrix drill down row value, I select an item that has more than 5k records from filter, at the time of drill down from matrix, it displays an error as 'Visual exceeded error try filtering out the records', but it's not an option for me,

please help @amitchandak @Daniel29195 @lbendlin @Ritaf1983 

[Daniel29195 · Accepted solution]

@Neha_12 

if the fields used in values section are measures, you need to make sure that your measures are optimized. 

+  you need to make sure that the model you working with is optimized. 

i faced the same problem with one the reports i was working on at my company. 

i redo  the model from scratch, and the matrix which gave me this error,  now shows the data in less than 1 sec. 

now one think you can do also, is select the item, and while the visual is loading, start removing fields from the matrix, to see which one is taking that long to finish and try working from there. 

now another thing to take in mind, sometimes this error can happen locally, but on the service you dont have this problem . 

hope this helps. 

let me know if you have any concerns or questions . 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Neha_12]

Thanks for replying!

could you please help me with the steps you follow to optimize model.

As for me I have 4-6 fact tables along with dimension tables, all facts are connected via many to many also the level of  granularity data connected  with all the facts together are different.

Measure created are not complex too. It's kind of multiplying two columns from different tables or subtracting two columns from different tables

[Daniel29195]

@Neha_12 

all facts are connected to each other ? 

[Neha_12]

Yes

[Daniel29195]

@Neha_12 

this is not a good thing to have in your model.

your model should follow a star schema 

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema