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) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 925
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 343
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Hiroyuki Murai
Mark Allen
Yves Gagnon
PATRICK WALTER
Carley Brice
Ash Rahman
Christelle Lamprecht
Wei Kwok Tey
Partha Pratim Nandy
Inge Rousseau
Forum Stats:
Groups: 3
Forums: 25
Topics: 7087
Posts: 31061
Member Stats:
Guest Posters: 49
Members: 34503
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —