
Gejza Horvath
New Member
Members

Forum Posts: 2
Member Since:
July 19, 2022
July 19, 2022

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:\Testdata\Xml\Import_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:
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Srikanth Amudhan
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Tom Lewis
Jennifer Rodriguez-Avila
Forum Stats:
Groups: 3
Forums: 24
Topics: 6542
Posts: 28641
Member Stats:
Guest Posters: 49
Members: 32829
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
