Solved: Resources Exceeded when adding a column

AmiraBedh · ‎04-26-2022

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 :

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

amirabedhiafi · ‎04-30-2022

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.

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini

View solution in original post

amirabedhiafi · ‎04-30-2022

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.

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini

Anonymous · ‎04-29-2022

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 · ‎04-26-2022

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

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

AmiraBedh · ‎04-27-2022

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

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696