XML File not loading

[Anonymous]

Hi All,

I am rying to load a local XML file stored on my machine to PBI Desktop. I am using the XML connection, but when it gets to 3GB it just stops loading and will sit there for ever. It looks like it's still loading as the little wheel turns, but it will just stay on "3GB from .... .xml"

The file is just a bit bigger than 3GB so in theory it should be close to done. What am I doing wrong?

Kind Regards

[v-eqin-msft · Accepted solution]

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.