metricsign
Start free
Medium severityconfigurationMicrosoft Fabric

Power BI Refresh Error:
Fabric Copy Activity Error 20741

What does this error mean?

The 'fileMissing' skip error file setting is not supported in the current copy activity configuration. This option is only available when using direct binary copy with a folder as the source.

Common causes

  • 1The 'fileMissing' property is set in skipErrorFile but the copy activity is not configured for direct binary copy with a folder source
  • 2Copy activity is using file-level or non-binary copy mode where skip-missing-file is not applicable
  • 3Pipeline was migrated or templated from a scenario that supported fileMissing but the current source/sink configuration does not

How to fix it

  1. 1Step 1: Open the copy activity settings in your Fabric Data Factory pipeline.
  2. 2Step 2: Navigate to the 'skipErrorFile' section of the copy activity payload (JSON or UI settings).
  3. 3Step 3: Remove the 'fileMissing' property from the skipErrorFile configuration.
  4. 4Step 4: If skip-missing-file behavior is required, reconfigure the copy activity to use direct binary copy with a folder as the source.
  5. 5Step 5: Save and re-run the pipeline to verify the error is resolved.

Frequently asked questions

Can I use 'fileMissing' skip behavior with non-binary copy modes?

No. The 'fileMissing' option in skipErrorFile is exclusively supported with direct binary copy when the source is a folder. For other copy modes, you must remove this setting.

What is direct binary copy with folder?

Direct binary copy with folder means the copy activity reads files as raw binary without transformation, using a folder path (not a single file) as the source. This mode supports additional fault-tolerance options like fileMissing.

Other configuration errors