Forum Discussion

TK12345's avatar
TK12345
Resolver II
3 months ago

Copy Data with VNET gateway error

Hi all,    I have an issue with my SQL Server / Azure SQL Database extraction. As you can see I connected to my source using a VNET gateway, and I do see the preview data. This table contains 37 ro...
Need Help
pipelines
Show and Tell
TK12345's avatar
TK12345
Resolver II
3 months ago

Hi there, 

It is a SQL Server in a private network, reachable througout my VNET. 
LIMIT 1 / TOP 1 still gives me directly the preview but the copy activity still stays in transfer state for a few minutes before giving the same error message.

v-aatheeque's avatar
v-aatheeque
Community Support
3 months ago

Hi TK12345 

Thanks for the update and for validating all the suggested troubleshooting steps.

Since the source preview is working successfully, even minimal queries such as TOP 1 are returning data correctly, but the Copy Activity consistently fails during the transfer/write phase to the Lakehouse, this behavior appears to be related to the VNET gateway network path, OneLake/Azure Storage connectivity, or a backend Fabric service issue rather than the SQL source itself.

 

As the issue persists even after recreating the pipeline, connection and Lakehouse, the next recommended step would be to raise a Microsoft Fabric Support and Status | Microsoft Fabric  for deeper backend investigation.