Medium severitydata source
Power BI Refresh Error:
XmlAttributeColumnNameConflict
What does this error mean?
An XML element has an attribute whose name conflicts with a child element name at the same level. ADF cannot flatten the structure when names collide.
Common causes
- 1The XML file has an element that contains both a child element and an attribute with the same name
- 2The XML namespace prefix creates a naming collision when ADF flattens the XML into a tabular structure
How to fix it
- 1Enable the "Attributes node name" setting in the XML source dataset to prefix attribute names and avoid conflicts.
- 2Use an ADF data flow transformation to read the XML with schema drift and handle the naming conflict explicitly.
- 3If you control the XML source, rename the conflicting attribute or element to eliminate the collision.
Frequently asked questions
Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-xml