error data refresh

[Anonymous]

Hi everyone,

I have a data flow connecting to an odata in premium and has introduced constant errors on refresh, follow bellow some examples

Error: PipelineException: Container exited unexpectedly with code 0x0000DEAD. PID: 9640. .. RootActivityId = fa36fb16-7bff-4577-913e-06b7b1ef7d24.Param1 = PipelineException: Container exited unexpectedly with code 0x0000DEAD. PID: 9640.  Request ID: 0e2e0b45-650e-4bcf-878e-ad9f94523b3e.

Error: The current operation was canceled because one or more operations failed... RootActivityId = fa36fb16-7bff-4577-913e-06b7b1ef7d24 Request ID: 0e2e0b45-650e-4bcf-878e-ad9f94523b3e.

Error: One or more upstream operations failed... RootActivityId = fa36fb16-7bff-4577-913e-06b7b1ef7d24 Request ID: 0e2e0b45-650e-4bcf-878e-ad9f94523b3e.

Error: One or more upstream operations failed... RootActivityId = fa36fb16-7bff-4577-913e-06b7b1ef7d24 Request ID: 0e2e0b45-650e-4bcf-878e-ad9f94523b3e.

Error: One or more upstream operations failed... RootActivityId = fa36fb16-7bff-4577-913e-06b7b1ef7d24 Request ID: 0e2e0b45-650e-4bcf-878e-ad9f94523b3e.

Error: One or more upstream operations failed... RootActivityId = fa36fb16-7bff-4577-913e-06b7b1ef7d24 Request ID: 0e2e0b45-650e-4bcf-878e-ad9f94523b3e.

Error: One or more upstream operations failed... RootActivityId = fa36fb16-7bff-4577-913e-06b7b1ef7d24 Request ID: 0e2e0b45-650e-4bcf-878e-ad9f94523b3e.

Error: One or more upstream operations failed... RootActivityId = fa36fb16-7bff-4577-913e-06b7b1ef7d24 Request ID: 0e2e0b45-650e-4bcf-878e-ad9f94523b3e.

[Anonymous]

Thanks for the answer @v-xulin-mstf 

a doubt, if i use a ppu license, would this problem stop occurring? Our environment is shared and it is difficult to make this change in atual scenario.

[HarishKM]

@Anonymous Hey Try this.
Found something similer on this group.

I went to the local cache for Power Bi (something along the lines of C:\Users\username\AppData\Local\Microsoft\Power BI Desktop\Cache) and deleted all files found there.  Once I did that I went back into my existing data model and everything is working again.

https://social.technet.microsoft.com/Forums/en-US/e5c8a3b6-2604-41c3-88cf-152b69b6c091/microsoftmashupevaluatorinterfaceerrorexception-container-exited-unexpectedly-with-code?forum=powerquery

[v-xulin-mstf]

Hi @Anonymous

Please try below suggestions:

There is a semantic difference when the entities are referenced from DF in same workspace vs DF is a different workspace with respect to the compute engine. In the same workspace case, the dataflows have a strong reference to each other and are updated in the same transaction. Hence we do not need to cache data and can refer to the data from the upstream entity. However, when they come from different workspace, the references are weak references and in order to be self-contained within a workspace we do need to re-cache the data. The re-caching step is what adds the additional time in processing.

To mitigate this we suggest

1. Increase dataflows’ max memory % and decrease the Datasets max memory % by same quantity. (If they have default settings then increase dataflows to 40% and decrease Datasets to 80%)
2. Increase Dataflows container size to 1500Mb. This will reduce parallelism and potentially reduce intermittent failures.

Best Regards,

Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.