Dataflow gen2 leaves broken table in lakehouse after update

[HannaIngrin]

Hi,

Setup

In Fabric i have multiple Dataflows gen2 writing from Business Central API to my Bronze Lakehouse. 

I'm always able to view my data in the preview of the DataFlow. 

Issue

When i refresh my dataflow (either manually triggering a refresh, via Pipelines or schedule refresh), it sometimes leaves a broken table, that is not able to read any data.

Insted of my data, i get this in the lakehouse:

I don't get any errors or indications that it is broken and often i just need to trigger a new refresh to get the table again. 

Does anyone have any toughts on what cloud be wrong or a good workaround?

Thanks in advance!

[miguel]

It could be that your table is still being processed and you're seeing a cached version of the table before it got populated with the new data.

id recommend reaching out support team by raising a support ticket so they can further investigate.

however, if you're able to consistently reproduce this behavior please do share the repro steps so we can look into it.