Forum Discussion
Dataflow Gen2 error failed with status 22
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
Hi Anonymous
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.
1 Reply
Hi Anonymous
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.