OLE DB or ODBC Error

tpmobley · ‎10-26-2022

I have a data source that has been working fine until recently, when all of a sudden it gives me the following error when I refresh it:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormat.Error] Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: '.', hexadecimal value 0x00, is an invalid character. Line 1, position 1.). '.

Two things I don't understand with this error: 1) It shows me all the rows of data in Power Query Editor without a problem, but only gives the error when I click 'Close & Apply', 2) I am not sure what document it is referring to when it says "Line 1, position1".

As far as the data source goes, I am using a 'Folder' input where all documents in that folder are XML files. Again, everything has worked fine for the longest time.

tpmobley · ‎11-10-2022

I removed all but one file in the folder and reran the data refresh, which then gave the real file location (not line 1, position 1). The problem is that mid-way through the XML file there is a block of 'NUL' that goes all the way to the end of the file. I'm just wondering if anyone know what may cause this?

tpmobley · ‎11-02-2022

I'm still looking for an answer to what the error message is referring to when it says "Line 1, position1". How do I identify the document, file, folder, etc. it is referencing?

tpmobley · ‎10-26-2022

Thanks for the reply, @truptis ...Part of the problem is... Line 1, position 1 of what? That's what's not making sense to me. The original XML files? The Advanced Editor in Power Query? It's complaining about a period '.' but I don't see what it's referring to. As to using XML instead of the Folder input, that's not feasible for my use case. I have hundreds of XML files, which is why I was using 'Folder' option instead.