Hi,
I am facing an issue enabling incremental refresh on a table inside a data flow. The same table loads without any problem when the Incremental Refresh settings are disabled. Issue details available in Refresh logs are given below:
Error: PipelineException: Container exited unexpectedly with code 0x0000DEAD. PID: 38640. . RootActivityId = c2e5436f-174c-46ef-ba64-e3ead2e12888.Param1 = PipelineException: Container exited unexpectedly with code 0x0000DEAD. PID: 38640. Request ID: 09060eae-74aa-0932-2d6d-f5852ff41bd8.
Here are a few things I have already done to overcome this problem:
- Creating a new dataflow and creating this table from scratch so there is no typo/mistake
- Dividing dataflow into two sub-dataflows
- Staging dataflow: Getting data from Cosmos and storing it in tabular form
- Transformational dataflow: Doing transformations (grouping, merging, and unpivoting columns
- Trying out different archive and data refresh period settings
This dataflow is in a workspace with premium capacity.
