Dataflow Gen2 error failed with status 22

[BashirIsmail]

the Dataflow Gen2 component has unexpectedly stopped working, displaying the error: "Operation on target **** failed: Dataflow refresh transaction failed with status 22."
the source : Excel file in SharePoint and distination Lakehouse table, Fabric Region UK

[Anonymous · Accepted solution]

Hi @BashirIsmail 

This error, "Dataflow refresh transaction failed with status 22," has been reported by other users as well.

In this case, as a temporary workaround, consider using Azure SQL as the destination instead of the Lakehouse table.

Dataflow refresh transaction failed with status 22 - Microsoft Fabric Community

Regards,

Nono Chen

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