Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

XML File not loading

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

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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:

     

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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:

     

    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.