Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Issue: Scheduled refreshes failing due to 'not enough memory' errors

Hi guys

 

Not sure where else to submit a ticket so figure it's here. Last couple of days a number of our dashboards that are scheduled to refresh multiple time per day have begun failing with 'not enough memory' errors reported. Might need to look at your servers.

eg.

 

An error occurred while processing the data in the dataset.

Refresh failed:

Customer Dashboard - DQ has failed to refresh.
Failure details: There's not enough memory to complete this operation. Please try again later when there may be more memory available.

Next refresh for Customer Dashboard - DQ is scheduled for September 9, 2022 1:00 UTC.

 

 

Technical Information

 

 

Activity Id:

4330716f-8ce3-42db-a301-6a7888826e0d

 

Request Id:

106a8cb9-53d9-4e8b-ad7a-2ebb71f64c98

 

Cluster Name:

WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net

 

Refresh Start Time:

September 8, 2022 22:53 UTC

 

Refresh End Time:

September 9, 2022 0:24 UTC

Status: Delivered

Hi @Gazmeist ,

 

It is obviously that the error caused by your memory limitation. 

vmengzhumsft_0-1663147915757.png

1.you can reduce your size of datasets as soon as possible. In your datasets, too much complex query will consume large memory. As you mentioned, you will refresh multiple dashboards, if they come from different datasets,  it would involve more queries and more easier to memory overload. So you can simplify your queries.

 

2. configure incremental refresh 

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs

 

3. Also, if you are in premium capacity, you can buy higher SKU or configure autoscale.

Power BI Premium Gen2 capacity load, overload, and autoscale - Power BI | Microsoft Docs

 

Best regards,

Community Support Team Selina zhu

 

 

Comments
Anonymous
Not applicable

This is painful.  I am also having refreshes to pbix files fail for circular reference to a table, which was never an issue in the past.  Refresh again and it's fine.  Developers need to do their due diligence in testing these "features".

v-mengzhu-msft
Community Support
Status changed to: Delivered

Hi @Gazmeist ,

 

It is obviously that the error caused by your memory limitation. 

vmengzhumsft_0-1663147915757.png

1.you can reduce your size of datasets as soon as possible. In your datasets, too much complex query will consume large memory. As you mentioned, you will refresh multiple dashboards, if they come from different datasets,  it would involve more queries and more easier to memory overload. So you can simplify your queries.

 

2. configure incremental refresh 

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs

 

3. Also, if you are in premium capacity, you can buy higher SKU or configure autoscale.

Power BI Premium Gen2 capacity load, overload, and autoscale - Power BI | Microsoft Docs

 

Best regards,

Community Support Team Selina zhu