My Power Query project processes 6 xml files and works fine since several months. Today the refresh command fails with error:
Operation is not valid due to the current state of the object
and other 165 lines of trace.
The error appears on the first line of the code:
let Source = Xml.Tables(File.Contents(" G:TestdataXmlImport_To_PQ_Fails.xml"), null, 1250) in Source
The result is the same when I try to open this file from the UI Data - Get Data - From file - Xml.
Using Win 10 + Excel 365 latest update.
When I reduce the size of the xml file from 4,5 MB to 2,5 MB it is imported with no errors.
Tested on another computer, got the same error. What went worng?
You can download xml files here:
https://www.dropbox.com/sh/duqlsdhjb2on0go/AAA5_LPjuTrK4i8bkiBfIj9Oa?dl=0
Could connect to the "Fails" file without problems. It opened immediately. And it loads 13310 rows upon Close& Load, from a table called "polozka".
The latest update Excel 365 to version 2206 15330.20264 solved the problem.