Importing XML file into POWER QUERY

[marciomendonca]

Hi community, good afternoon.

I'm facing this issue: I've been trying to import a XML File into Power Query, but, unfortunately it's not being straight forward as I expected and here is the problem:
It's being imported as a huge single column, where the first 32 rows correspond to the actual headers from the table that I was initially expecting to get

So, instead of having o single column with over 20k rows I want to get a table with 32 columns and its respective amount of rows.

Is it doable using Power Query? I mean to split a larger column into multiple columns using a counter (a split each 32 rows) as a delimeter.

Best regards.

[Bifinity_75 · Accepted solution]

Hi @marciomendonca , you can transpose the table in Power Query:

But to work with XML files I always create a star data model, like the image:

model compression will improve and result in a smaller Pbix file, and better performing.

Best regards