Resources Exceeded when adding a column

[AmiraBedh]

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 :

[amirabedhiafi · Accepted solution]

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.

[Anonymous]

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

[amitchandak]

@AmiraBedh , You need to simplify your table/column calculation.

You can increase the memory management cache(8-10GB)  along with these settings and try

[AmiraBedh]

I have the following settings and I already tried to clean the cache but the issue still persist :