High severityfabric
Power BI Refresh Error:
Lakehouse Data Copy Operation Failed
What does this error mean?
A copy activity or pipeline transferring data to or from a Fabric Lakehouse failed due to network connectivity problems, TLS/SSL handshake failures, or authentication issues in the integration runtime. The error can occur in both Azure IR and self-hosted IR environments.
Common causes
- 1Network instability or a dropped TCP connection between the integration runtime and the Lakehouse ABFSS endpoint
- 2TLS/SSL certificate validation failure — common when the integration runtime machine's root CA certificates are outdated
- 3The integration runtime cannot reach the Fabric service endpoint due to firewall or proxy restrictions
- 4Lakehouse access credentials (Shared Access Signature or service principal) have expired during a long-running copy
Beyond the docs
The official documentation does not cover this error — these are community-tested approaches.
- 1Retry the copy activity — transient network issues often resolve on retry
- 2If the error message contains 'SSL' or 'TLS': update the root CA certificates on the self-hosted integration runtime machine and restart the IR service
- 3Check that the IR machine can reach the Fabric ABFSS endpoints (*.dfs.core.windows.net and *.blob.core.windows.net) on port 443
- 4If using SAS tokens, verify they haven't expired; rotate and update the credentials in the linked service
- 5Review the IR logs on the host machine for the specific SSL or network error code for targeted diagnostics
Official documentation: https://learn.microsoft.com/en-us/fabric/data-engineering/troubleshoot-lakehouse