XML with lots of hierarchies - How best to model

[DebbieE]

I have quite a lot of XML files and they all contain lots of hierarchies.

My Question is, in Power BI what is the best way to deal with this. Where you can keep everything in the same table 

OR

Create duplicate tables keeping just 1 hierarchy with the primary key. Then you can join the tables together afterwards.

I dont want to go down the first route and then be told that the best way is to put everything into seperate tables

Any help would be greatly appreciated

[LivioLanzo]

@DebbieE

This depends on the contents of the XML Files so there's no general answer. Of course if you have with one big flat table which can benefit from normalization then you should normalize

[DebbieE]

That does make sense.

The only thing that worries me. I upload all my XML files and they contain a lot of data and it takes just over half an hour to load into Power BI

If I have to Duplicate the table to create all the linked tables, would that be creating a lot of work for Power BI?