What causes Fabric Copy Activity Error 20742?

The 'dataInconsistency' property is set in skipErrorFile but validateDataConsistency is not enabled in the copy activity. Copy activity is not in direct binary copy mode, making the dataInconsistency skip option incompatible. Pipeline was copied from another workspace or template where validateDataConsistency was active but that setting was not carried over

How do I fix Fabric Copy Activity Error 20742?

Step 1: Open the copy activity settings in your Fabric Data Factory pipeline.. Step 2: Locate the 'skipErrorFile' section of the copy activity payload.. Step 3: Remove the 'dataInconsistency' property from the skipErrorFile configuration.. Step 4: If data inconsistency skipping is required, ensure the copy activity uses direct binary copy mode AND set 'validateDataConsistency' to true in the activity settings.. Step 5: Save and re-run the pipeline to confirm the error is resolved.

Medium severityconfigurationMicrosoft Fabric →

Power BI Refresh Error:
Fabric Copy Activity Error 20742

What does this error mean?

The 'dataInconsistency' skip error file setting is not supported in the current copy activity configuration. This option is only valid when using direct binary copy with validateDataConsistency set to true.

Common causes

1The 'dataInconsistency' property is set in skipErrorFile but validateDataConsistency is not enabled in the copy activity
2Copy activity is not in direct binary copy mode, making the dataInconsistency skip option incompatible
3Pipeline was copied from another workspace or template where validateDataConsistency was active but that setting was not carried over

How to fix it

1Step 1: Open the copy activity settings in your Fabric Data Factory pipeline.
2Step 2: Locate the 'skipErrorFile' section of the copy activity payload.
3Step 3: Remove the 'dataInconsistency' property from the skipErrorFile configuration.
4Step 4: If data inconsistency skipping is required, ensure the copy activity uses direct binary copy mode AND set 'validateDataConsistency' to true in the activity settings.
5Step 5: Save and re-run the pipeline to confirm the error is resolved.

Frequently asked questions

Do I need both validateDataConsistency and direct binary copy to use the dataInconsistency skip option?

Yes. Both conditions must be met: the copy activity must use direct binary copy mode, and validateDataConsistency must be set to true. Without both, the dataInconsistency skip setting is not supported.

Will removing dataInconsistency from skipErrorFile cause the pipeline to fail on inconsistent data?

Yes, without the skip setting, data inconsistencies detected during copy will cause the activity to fail rather than skip the problematic files. Weigh this against your data quality requirements.