Forum

Operation is not va...
 
Notifications
Clear all

Operation is not valid due to the current state of the object

3 Posts
2 Users
0 Reactions
190 Views
(@horvathg)
Posts: 2
New Member
Topic starter
 

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

 
Posted : 20/07/2022 6:58 am
Riny van Eekelen
(@riny)
Posts: 1189
Member Moderator
 

Could connect to the "Fails" file without problems. It opened immediately. And it loads 13310 rows upon Close& Load, from a table called "polozka".

 
Posted : 20/07/2022 7:33 am
(@horvathg)
Posts: 2
New Member
Topic starter
 

The latest update Excel 365 to version 2206 15330.20264 solved the problem.Kiss

 
Posted : 20/07/2022 9:58 am
Share: