Mitigate The M evaluation exceeded the memory limit

[ykotamraju]

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.

[v-yetao1-msft]

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]

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.