Forum Discussion
Error: Resource Governing
Hi DMSJennifer ,
Depending on the data source and the number of fields (measures or columns), a visual may load slowly. We recommend limiting visuals to 10-20 total fields, both for readability and performance reasons.
The upper limit for visuals is 100 fields (measures or columns). If your visual fails to load, reduce the number of fields.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So this looks like the scenario I wrote about in one of the blog posts above - you have a measure that never returns a blank. This can be a cause of memory spikes.
exactly. Just in my case i never wanted to return blank at KEY ACCOUNT level. Although the Matrix had just <100 rows at maximum with 8 measures. And Fact table from where all the measures were calculating results from is <100k. So in theory the there were not many data points in this visual , even if its expanded to the lowest level ( i had 3 fields in the ROWS section of the matrix).
Also one thing i noticed was that i got this error only when drilling down on a specific category from Level 1 to Level 2 to KEY ACCOUNT (3rd level).
However once you drill down via buttons on the top right of the matrix visual and expand all rows to the lowest level, the visual loaded just fine.
So something really weird going on with the way PowerBI handles it.
I would expect that expansion of single row takes fewer memory than expanding all categories.