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.
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.