Forum Discussion

DucLuong's avatar
DucLuong
Frequent Visitor
6 years ago
Solved

Xml processing failed. Internal error: '\b', hexadecimal value 0x08, is an invalid character.

Hi everyone,   I have a Power BI dashboard that gets data from an RSS feed of a service provider (Request Tracker).   Normally the connection works fine but recently, due to some customers mistak...
Need Help
  • DucLuong's avatar
    DucLuong
    6 years ago

    I'm posting a solution I found here in case anyone runs into the same problem. The beauty of this is that you can do it without much programming knowledge like I am.

     

    What worked for me is to use Power Automate to get xml file, look into its content, strip the invalid characters before saving the file to SharePoint. After that, I only need to establish data connection between Power BI and the sanitised xml file on SharePoint.

     

    The solution can be found here. It belongs to AlanPs1 and all credits should be given to him for a very neat solution.

lbendlin's avatar
lbendlin
Super User
6 years ago

Post a sanitized version of your Power Query code and I will show you how to include the error handling.

DucLuong's avatar
DucLuong
Frequent Visitor
6 years ago

 

let
    Source = Xml.Tables(Web.Contents("https://................../?Order=ASC%7CASC%7CASC%7CASC&OrderBy=id%7C%7C%7C&Query=Queue+%3D+%27Property%27+AND+Created+%3E+%2712+DAYS+AGO%27")),
    ......
in
    #"Filtered Rows"

 

 

I don't know programming so what you see above is entirely generated by Power Query. There are other lines but I didn't include them as they are just commands to expand tables, remove, filter, etc.