Forum Discussion
Power Query: Load xml suddenly fails - due to file size?
I have helped clients with a number of Excel solutions where Power Query is a part. In a reporting solution I get data from a number of sources in xml-format. It has been working for more than a year...
Hey!
Could you please share a sample file where I could repro this behavior? I've been attempting to repro the bug, but I'm unable to do so.
Is this happening in Power Query for Excel? in Power BI Desktop? or is this in the Power Query Online experience through Power BI Dataflows? if it's in any desktop application, what's the version of the desktop app that you're using and the Power Query version?
OBS: See edit of my original post.
Here is a link to a Dropbox folder with 2 files:
filesize-test.xlsx with a simple query. You must edit the source in the query to the correct path.
InvoiceLines.xml which is too large (5.316 kb)
I run PQ from Excel desktop.