Forum Discussion
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
- lbendlinSuper User
PBI Desktop uses your local RAM. The online report uses the capacity memory and has to adhere to any limits your capacity/tenant admin may have set.
Use DAX Studio to evaluate the query. Look for excessive number of records. Refactor your query.
- HersheyAshNew Member
Hi Ibendlin,
Can you share how to use DAX studio to improve on the measure? As i'm still new to PBI.
Thanks