Forum Discussion
Schedule Failed due to memory
Hi Everybody,
Schedule for a report has failed & I got the below error. Currently the schedule is running fine without any changes. Please let me know what should be done/Options to look at to not have this issue again.
Error:
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. Container exited unexpectedly with code 0x0000DEAD. PID: 10436. Used features: (none).;Container exited unexpectedly with code 0x0000DEAD. PID: 10436. Used features: (none). Container exited unexpectedly with code 0x0000DEAD. PID: 10436. Used features: (none). Container exited unexpectedly with code 0x0000DEAD. PID: 10436..
Thanks
8 Replies
- lbendlin
Super User
How busy is your capacity? Are you on Premium? if so, what SKU? Have you migrated to v2 yet?
Hi lbendlin ,
I am a power bi Pro user. I do not have the access to premium & capacity settings.
Thanks
- lbendlin
Use DAX Studio to troubleshoot your measures and reduce the number of loops/rows your DAX formulas produce. The Italians have a couple of excellent videos on measure performance optimization.
rjhartopHelper II
This seems to be a Power Query rather than DAX issue
- lbendlin
You are right, apologies for the oversight. Power Query also has diagnostics options. They are not as elegant as DAX studio but they still allow you to identify which transforms use up the most time (and potentially the most memory). Look for any merge transforms across large tables. There is a difference in performance depending on the direction of the merge between a large and a small table, for example.
- rjhartop
I am having the same issue. I am unable to see a memory limit or adjust it. I have a PPU workspace (Gen 2 refreshes). Before Christmas, datasets three times the size used to run in an hour and a half, now I get this error:
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. Container exited unexpectedly with code 0x0000DEAD. PID: 40088. Used features: (none).;Container exited unexpectedly with code 0x0000DEAD. PID: 40088. Used features: (none). Container exited unexpectedly with code 0x0000DEAD. PID: 40088. Used features: (none). Container exited unexpectedly with code 0x0000DEAD. PID: 40088.
Rajesh_YarlagadHelper I
Hi
Isthere a solution to this issue ? I am facing same issue on some of the smaller datasets which are not even 10MB
