Copy Data Activity can't write to Lakehouse

[shivanshkhatri]

I am encountering an issue while copying data from an on-premises SQL Server to a Fabric Lakehouse. Although the data is previewed and read correctly during the process, the actual write operation does not complete. The Copy Data activity shows that all rows are read, but the writing phase remains stuck for hours, even when the data size is less than 5 MB.

Additionally, the destination settings for the copy operation are configured to overwrite the table. While an empty table is created in the Lakehouse, no data or files are written to it.

Notably, we have another connection using the same data gateway, and it works perfectly. However, this specific setup consistently encounters the described issue.

[lbendlin · Accepted solution]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .