cancel
Showing results for 
Search instead for 
Did you mean: 
0

Mitigate The M evaluation exceeded the memory limit

Hi

 

Observed the following Error :

AzD has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

The M evaluation exceeded the memory limit. To address the issue consider optimizing the M expressions, reducing the concurrency of operations that are memory intensive or upgrading to increase the available memory. <ccon>Evaluation ran out of memory and can't continue.</ccon>;<ccon>Evaluation ran out of memory and can't continue. Evaluation ran out of memory and can't continue. Exception of type 'System.OutOfMemoryException' was thrown. Exception of type 'System.OutOfMemoryException' was thrown. Exception of type 'System.OutOfMemoryException' was thrown.</ccon>. Table: AzDCapacityDetails_QuotaSegmentToDFSegment.

Next refresh for AzD is scheduled for August 9, 2022 18:00 UTC.

 

 

 

Activity Id:

6e6ebb52-7254-4ce5-8a3e-eb3d487bb046

 

Request Id:

caa8d6a3-c4ac-458d-a5f4-2c7d268c0143

 

Cluster Name:

DF-MSIT-SCUS-redirect.analysis.windows.net

 

Refresh Start Time:

August 9, 2022 15:03 UTC

 

Refresh End Time:

August 9, 2022 15:19 UTC

 

The Table mentioned in error : AzDCapacityDetails_QuotaSegmentToDFSegment has mererly 50 rows and 2 columns data. 

There are other tables queried from kusto during refresh.

 

This Error occurred once and in next refresh it was successful.

Tried replicating issue by running refresh in Power BI Desktop and with Diagnostics, see no clue and refresh happens fine.

Is Capacity not sufficient ? how to find that data ? should we increase capacity ? If yes what steps are to be followed for that ?

Please help in understanding how to find root cause and next steps to fix this issue.

 

 

Status: Delivered

Hi @ykotamraju 

You can optimize your data model in Desktop first .  

Dataset modes in the Power BI service - Power BI | Microsoft Docs

Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...

Environment and optimization of capacity, you can refer to this document below

Optimization guide for Power BI - Power BI | Microsoft Docs

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
Ailsa-msft
Community Support
Status changed to: Delivered

Hi @ykotamraju 

You can optimize your data model in Desktop first .  

Dataset modes in the Power BI service - Power BI | Microsoft Docs

Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...

Environment and optimization of capacity, you can refer to this document below

Optimization guide for Power BI - Power BI | Microsoft Docs

 

Best Regards,
Community Support Team _ Ailsa Tao

ykotamraju
Microsoft

As already mentioned the Table AzDCapacityDetails_QuotaSegmentToDFSegment has mererly 50 rows and 2 columns data. Why are we getting Out Of Memory Issue while loading this Table. Can you please check from your internal logs what is the Memory used and what is Memory available when this Error was observed.