XML connection error

[CDEC]

Hi all, 

I keep running in to a refresh error for my XML file. Background: A user accidentally changed the authentication token in our data source to which the XML file is connected to. the token was changed back to the original, but since then, when the table refreshes automatically, we encounter this error code: 

DataFormat.Error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: Reference to undeclared entity 'nbsp'. Line 4, position 23.). . The exception was raised by the IDbCommand interface. 

Things that temporarily fixes it was to create a new parameter with the authtoken and then reference the xml file via dax to the new parameter it worked for about 24h, but when the next scheduled refresh came through, it failed again. always the same error code. 

Thanks in advance, 
L 

[Anonymous · Accepted solution]

Hi @CDEC ,

Regarding your question, could you please review your XML file: Line 4, position 23.

Replace 'nbsp' in the file with '&#160'.

Related content can be found in the following articles.

.net - Reference to undeclared entity 'nbsp' while reading xml from URL in c#? - Stack Overflow

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.