What causes UserErrorInvalidDataValue?

A source column contains null values in a non-nullable target column. A string value cannot be parsed as the target numeric or date type. Type mismatch between source data and the defined schema in the ADF dataset

How do I fix UserErrorInvalidDataValue?

Enable fault tolerance on the copy activity to skip rows with invalid values and log them to storage.. Review the source data for values that do not conform to the expected data type.. Update the dataset schema to use a more permissive type (such as string) for the affected column.. Use a data flow transformation to cleanse or cast the problematic values before writing to the sink.

Medium severitydata source

Power BI Refresh Error:
UserErrorInvalidDataValue

What does this error mean?

ADF encountered a data value in the source that cannot be converted to the target column type. The source data contains values incompatible with the defined schema.

Common causes

1A source column contains null values in a non-nullable target column
2A string value cannot be parsed as the target numeric or date type
3Type mismatch between source data and the defined schema in the ADF dataset

How to fix it

1Enable fault tolerance on the copy activity to skip rows with invalid values and log them to storage.
2Review the source data for values that do not conform to the expected data type.
3Update the dataset schema to use a more permissive type (such as string) for the affected column.
4Use a data flow transformation to cleanse or cast the problematic values before writing to the sink.

Frequently asked questions

Does this error affect all pipeline runs or just the current one?

Depends on the root cause. A persistent misconfiguration fails every run; a transient issue may resolve on retry. Check the run history.

Can this error appear in Azure Data Factory and Microsoft Fabric pipelines?

Yes — the same connector errors appear in both ADF and Fabric Data Factory pipelines.

How do I see the full error detail for an ADF pipeline failure?

In ADF Monitor, click the failed run, then the failed activity. The detail pane shows the error code, message, and sub-error codes.

Will downstream Power BI datasets be affected when an ADF pipeline fails?

Yes — a dataset refreshing after the pipeline will use stale data or fail if the target table was cleared. The Power BI refresh may succeed while serving wrong data.

Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-fault-tolerance