DataFormat.Error: 'Text' is an invalid XmlNodeType

[aliyx19]

I'm querying from a folder and the reports in the folder are formatted the same with the .xlsx extension. However, I'm getting this error message. Any assistance with this would be appreciated

An error occurred in the ‘Transform File (2)’ query. DataFormat.Error: 'Text' is an invalid XmlNodeType. Line 1, position 468.
Details:
[Binary]

[Vera_33]

Hi @aliyx19 

I assume you used help query to read from a folder, can you try to avoid it? Here is one post, I replied on how to:

https://community.powerbi.com/t5/Power-Query/Avoid-Helper-Queries/m-p/1753052#M53003