Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm facing the below error while loading an XML file through Power Query
DataFormat.Error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: '<' is an unexpected token. The expected token is ';'. Line 1544, position 46.)
Details:
[Binary]
The file itself has this
<?xml version="1.0" encoding="iso-8859-1"?>
The issue is apparently with this line in the XML (and thereafter)
<ss:Cell><ss:Data ss:Type="String">FINCK&CO</ss:Data></ss:Cell>
I assume the & sign is not compatible with the encoding I've chosen or the creation of the file is using wrong encoding tag somehow?? I've tried multiple of the different encoding choices (multiple ISO's, UTF's, Latin1's). Does anyone have any idea how to solve this?
Solved! Go to Solution.
@sunam
I am not familiar with XML code, but it says "<" is the problem of this error. Did you make sure the xml code were written correctly.
Paul
Thanks Paul, I'm leaning towards the incorrect xml code as well. Did some digging on stackoverflow and looks like it just would need to be & instead of &. I'll still keep this "open" as I did not yet receive reply from the responsible parties to the actual xml document (ie. whether they think its correct or not).
@sunam
I am not familiar with XML code, but it says "<" is the problem of this error. Did you make sure the xml code were written correctly.
Paul