Error occured while running DAX in Power BI which is connected to SSAS using live connect mode

I have connected my SSAS with MS Excel and all the dax which i am running is working fine . Image of DAX result in MS Excel

But when i am connecting the SSAS with Power BI it is not running as expected and is giving Query exceeded the available resources . The Dax which i am running in Ms Excel runs in 3 mins and in power bi it is giving error .

DAX which i am running is

HF Customers:= 
VAR SelectedEnd   = MAX( Calender[date] )
VAR OneYearBack   = EDATE( SelectedEnd, -12 )
RETURN
COUNTROWS(
    FILTER(
        ALL(Customer_agg[customer_key]),                              
        CALCULATE(
            SUM(Customer_agg[unique_count_visit_key]),
            REMOVEFILTERS( Calender ),
            Customer_agg[Enriched_Business_Date] >= OneYearBack,            
            Customer_agg[Enriched_Business_Date] <= SelectedEnd
        ) > 5                                                      
  )
)

The Customer_agg cube in SSAS has 36 million records and other cubes has less than 1000 records.

The small dax (ABCD CUstomer logic ) which i am running in Power bi is running fine IMAGE for ABCD customer logic dax which is running fine in POWER BI but when i am running HF cusomter logic dax it is giving error Image for HF customer logic dax which is giving error

The RAM Usage in system is below 50% when the dax is being calculated and i have 128 GB of RAM . I am using Visual studio 2022 version and SQL server 2025/ Azure Analysis services(1700)

My question is : Why the results for DAX is easily shown in MS Excel but fails in Power BI ? How can i show the DAX which is running in MS Excel should also run in POWER BI and visualise the result .

Can somebody help me here ? I am stuck in this issue for more than a week now.