
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: Catalin Bombea
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 204
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Bhuwan Devkota
Kathryn Patton
Maria Conatser
Jefferson Granemann
Glen Coulthard
Nikki Fox
Rachele Dickie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6222
Posts: 27291
Member Stats:
Guest Posters: 49
Members: 31913
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
