Forum Discussion

Manoj_Raj_S's avatar
Manoj_Raj_S
New Member
2 years ago

Issue with large XML files

Hi all,

 

I have loaded 2 xml files of size 500 mb each into my powerbi desktop, which creates 2 fact tables and no dimension tables yet. Loading the xml files not takes much time but post loading, each time i open the query editior and even do a small tranformation for one of the table and try to load back to powerbi, it is taking me approximately 2 hrs. Why is it taking so long time? Is there anything that i could do to fix the processing time?
Please share your suggestions.

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Every time you mess with the meta data you get penalized with the "Evaluating..."  mocking prompt.

     

    Don't do any transformations. Or flatten the XMLs into a dataflow once and then do the transform downstream.

  • Manoj_Raj_S's avatar
    Manoj_Raj_S
    New Member
    2 years ago

    Thanks,  even splitting the huge xml file into 4 different files and then loading, appending data and performing transformation worked as well.