Error - Visual has exceeded the available resources

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