Table Visual resource limit?

[rmcgrath]

Does anyone know how to tell the limit of a table visual?  I am creating a dynamic Balance Sheet that uses several columns full of measures (using SWITCH).  I have exceeded the resource limit a couple of times now so it would be helpful to know what the resource limit is for a table visual and how you tell?

[vicky_ · Accepted solution]

Most visuals will only load in so many rows / columns / cells (at a time). I.e in the docs (https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-data-points#table)  the row "limit" for a table is 500 at a time, but if you keep scrolling, you should be able to see all the data eventually. As far as I know, there is no limit on the number of rows a table will show.

However, the exceeded visual resources error doesn't usually have anything to do with the specific visual. This error appears when your query is using too many resources (trying to calculate over too many rows, running for too long, etc.). If you have PowerBI premium, there might be ways to get your limits to increase - and you can reflect that in PowerBI desktop through the report settings. Chris Webb has a great article on that: https://blog.crossjoin.co.uk/2023/06/18/the-visual-has-exceeded-the-available-resources-error-in-pow... 

However, the best option would be to optimise your DAX code, or filter out more data to begin with, so that it consumes less resources.