XML File not loading

Hi Anonymous ,

Such error may be related to the data size.

If you want to import multiple xml files, please kindly refer to the steps provided in a similar thread:

1. Query the folder where your XML files are
2. Add a column that combines the path and file name to make an absolute path to the XML file and call it [Path]
3. Create an XML query to one of the XML files in the folder
4. Open advanced editor and create a parameter by adding (path as text) => at the top
5. Replace the path specified inside Folder.Files() to path
6. Close the advanced editor and name the query "getXML"
7. In the Folder Query, add a custom column and call the getXML function by stating getXML([Path])
8. Close and Load
   

    

Or there are eight different data reduction techniques covered in this article. These techniques include:

• Remove unnecessary columns
• Remove unnecessary rows
• Group by and summarize
• Optimize column data types
• Preference for custom columns
• Disable Power Query query load
• Disable auto date/time
• Switch to Mixed mode

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.