Forum Discussion
Visual exceeded the available resources matrix visual
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! 🤠
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
Yes
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