Gejza Horvath
New Member
Members
Forum Posts: 2
Member Since:
July 19, 2022
July 19, 2022
Offline
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:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 286
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Jeffree Bunning
Jackie Memije
John Franzon
Darcie Clayton
trevor mir
Ruby White
Marisa Bradshaw
Eugene Augustine
MacNaughton Finance
Tanu Rai
Forum Stats:
Groups: 3
Forums: 24
Topics: 6872
Posts: 30119
Member Stats:
Guest Posters: 49
Members: 33667
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —