Forum Discussion

HersheyAsh's avatar
HersheyAsh
New Member
3 years ago

Resources Exceeded

Hi There, 

 

When i refresh the dashboard in PBI desktop, the visual shows fine, but refreshed online, will give the error:

 

This query uses more memory than the configured limit. .......More details: consumed memory 1449 MB, memory limit 1331 MB

 

The visual is based on this measure to get last 3 month of Totat customer average :

 

TotalCustAvg_Last3Mth =
VAR MaxFactDate =
CALCULATE(MAX(TblA[Date]), ALL(Dim_BusinessDay))
VAR FDate =
ENDOFMONTH ( Dim_BusinessDay[Calendar_Date] )
VAR Edate =
EDATE ( FDate, -2 )
RETURN
IF (
MaxFactDate <= FDate
&& MaxFactDate >= Edate,
CALCULATE ( [TotalCust_Avg] , ALL ( Dim_BusinessDay ) ))

 

Why is it showing ok in PBI desktop but not online? Much help is appreciated. Thanks.

3 Replies