Xml processing failed

[swestendorp]

Hi all, 

I need help with an issue I am running into. 

We use an API to pull in XML data on our fleet of vessels from a supplier. When I test the connection using Postman I get the results I am looking for. However, when I use Power BI to load the information, some vessels return an error: 

DataFormat.Error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: '�', hexadecimal value 0x0B, is an invalid character. Line 2510, position 4.)
Details:
    [Binary]

I don't have access to the original XML Files and turning to the supplier for help was not a success. What would be the best approach to tackle this issue? 

Thanks a lot for your help!

[WestlyWhite]

I had this problem as well. Turned out to be a copy and paste error in my own DAX formula (coping from OneNote... not smart). Check your DAX formulas for special characters.

[Maryam_Pour]

Hi swestendort,

I have the exact same issue, and I couldn't updated my data since last month.
The supplier expects me to find the error and tell them where it is so they can remove it from the database.
I searched the API with Postman but couldn't find any suspected character. Therefore I'm totally stocked and can't do anything.

Has anybody a solution or code to add to the Advance Editor to ignore these types of characters?

[v-xicai]

Hi @swestendorp  ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[swestendorp]

Hi @v-xicai, 

Thank you for your suggestion. Unfortunately, I do not have access to the original XML files, I have only been provided with an API url. 

Best, 

Sifra

[v-xicai]

Hi @swestendorp ,

>>DataFormat.Error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: ' ', hexadecimal value 0x0B, is an invalid character. Line 2510, position 4.)

From your error message, you may check if there is an invalid character in Line 2510, position 4.

You can also try to connect to XML data using XML connector.

Best Regards,

Amy

Community Support Team _ Amy

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