Forum Discussion

sunam's avatar
sunam
New Member
5 years ago
Solved

XML encoding issue - unexpected token (string with &)

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?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

  • sunam's avatar
    sunam
    New Member
    5 years ago

    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 &amp; 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).