Power BI Refresh Error:
DWCopyCommandOperationFailed

What does this error mean?

COPY INTO to Azure Synapse or Fabric Data Warehouse failed. Network instability or server-side timeouts terminated the bulk load operation.

Common causes

• 1Network instability causes the server to forcibly close the TCP connection mid-copy
• 2Server-side timeout or resource limits terminate the long-running copy operation
• 3The error message reads: 'A transport-level error has occurred when receiving results from the server'

How to fix it

1. 1Check the server logs for the Data Warehouse and review network stability between the integration runtime and the server
2. 2Split the copy operation into smaller partitions instead of running one long-running copy — this reduces exposure to network interruptions
3. 3Add retry logic to the ADF pipeline activity to handle transient transport-level errors
4. 4If the error is intermittent, investigate network path stability between the self-hosted IR and the Data Warehouse endpoint

Other data source errors