Power BI Refresh Error:
Fabric Copy Activity Error 20701
What does this error mean?
The Copy Activity could not retrieve metadata for a source file needed to validate data consistency. This is typically caused by a transient issue on the source data store or insufficient permissions to read metadata.
Common causes
- 1A transient service disruption or throttling event on the source data store prevented metadata retrieval
- 2The identity or service principal used by the pipeline lacks permissions to read file metadata from the source
- 3The source file was deleted, moved, or renamed between the copy job start and the metadata validation check
- 4Network connectivity issues between the Fabric runtime and the source data store interrupted the metadata request
How to fix it
- 1Step 1: Check the health and availability of the source data store (e.g., Azure Data Lake Storage, Blob Storage, or other file store) at the time the error occurred.
- 2Step 2: Verify that the service principal or managed identity configured in the linked service has at least read and metadata-read permissions on the source container and files.
- 3Step 3: Confirm that the source file referenced in the error message ('%name;') still exists and has not been moved or deleted mid-pipeline.
- 4Step 4: Retry the pipeline run to determine whether the issue is transient; if it succeeds on retry, consider adding pipeline retry logic for this activity.
- 5Step 5: If the source store does not support metadata retrieval, disable the 'validateDataConsistency' option in the Copy Activity settings to bypass this check.