Error - Visual has exceeded the available resources

[_Bruce123]

HI Everyone,

I have a client who keeps getting this error on a table visual in Power BI Service and Desktop when filtering on a particular date. They are on a PPU capacity and have a 10GB max which is being exceeded. The dataset itself is 4MB and has two non-complex DAX calculations. In Power BI Service the Consumed Memory is 10240 MB, and the memory limit 10240 MB

Solutions I have tried so far: Power BI Desktop

1. Removing un-used columns

2. Removing un-used tables

3. Clicking off "Auto-Time Intelligence " to remove the local date tables from the data load in Power BI Desktop Options & Settings

4. Clearing Cache in Power BI Desktop Options & Settings

Solutions I've tried so far Power BI Service:

1. Admin Portal - Premeium Per User Settings --> Altrered (Minimum Refresh Interval & Minimum Execution Interval)

Power BI Service Error

Power BI Service Manage Group Storage Option

Power BI Desktop Error

DAX Studio - VertiPaq Analyzer - Tables

DAX STudio - VertiPaq Analyzer - Summary

DAX STudio - All Queries - Highlighted Query Fails

[ribisht17]

@_Bruce123 

https://community.powerbi.com/t5/Service/visual-has-exceeded-available-resources/m-p/115962

https://community.powerbi.com/t5/Power-Query/Resources-Exceeded-This-visual-has-exceeded-the-availab...

https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-troubleshooting-tile-errors/

https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/

Thanks,

Ritesh