Forum Discussion
Resources Exceeded when adding a column
I am having a report with a live connection to an SSAS Tabular model, where I am using a table visual with 28 columns
and 5 filters.
When I add other columns I encounter this error, knowing that the result of the filters is always one record :
It happened with me, when I was using some SUM/AVG calculations.
Try to filter your data using date filters for example.
For the SSAS Tabular, partitions may help a lot to get only data needed especially when dealing with historical data.
4 Replies
AmiraBedh , You need to simplify your table/column calculation.
You can increase the memory management cache(8-10GB) along with these settings and try
I have the following settings and I already tried to clean the cache but the issue still persist :
Hi AmiraBedh ,
Please check if this blog helps.
https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/
Best Regards,
Jay
It happened with me, when I was using some SUM/AVG calculations.
Try to filter your data using date filters for example.
For the SSAS Tabular, partitions may help a lot to get only data needed especially when dealing with historical data.
