Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

The M evaluation exceeded the memory limit.

Hello, Team. From past 2 days, some of the reports in the Premium Capacity Gen 2 are failing with this partciular error:  The M evaluation exceeded the memory limit. To address the issue consider op...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

 

What happens if you had to reduce the amount of steps and see if that resolves the issue?

 

You could also test this using Power BI Desktop and see when you refresh the dataset how much memory it consumes?

 

You could also enable the Power Query Diagnostsics to see where it is using a lot of resources?

 

Power BI Query Performance & Query Diagnostics | Paul Turley's SQL Server BI Blog

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

GilbertQ 

 

The report dataset is not heavy , when the refresh works fine it completes within 2 minutes and the total number of rows is slightly above 2 million,It does refreshes fine for few times in a day and for some refreshes it gives this error. So , do we really think that the queries used in the report would be causing this error ?

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 


    If it does refresh sometimes, then the issue has to do with there not being enough CPU's if using Gen2 to handle the refresh and query loads as far as I can see

     

    Have a look at the latest Premium metrics App and see what is happening when the refresh fails.

     

    What is Microsoft Power BI Premium? - Power BI | Microsoft Docs