What causes XmlValueColumnNameConflict?

An XML element has both a text value and an attribute or child element whose name matches the default ADF value column name (_value). The XML namespace configuration in the ADF dataset creates a column name collision with the value node

How do I fix XmlValueColumnNameConflict?

Configure the "Value column name" setting in the XML source dataset to change the default "_value" column name to a non-conflicting name.. Alternatively, restructure the XML source to avoid having text nodes and attributes with the same name.

Medium severitydata source

Power BI Refresh Error:
XmlValueColumnNameConflict

What does this error mean?

The column name ADF uses for XML text node values conflicts with an attribute or child element name in the same XML element.

Common causes

1An XML element has both a text value and an attribute or child element whose name matches the default ADF value column name (_value)
2The XML namespace configuration in the ADF dataset creates a column name collision with the value node

How to fix it

1Configure the "Value column name" setting in the XML source dataset to change the default "_value" column name to a non-conflicting name.
2Alternatively, restructure the XML source to avoid having text nodes and attributes with the same name.

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/connector-troubleshoot-xml