Forum Discussion
Importing XML file into POWER QUERY
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.
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
1 Reply
- Bifinity_75
Solution Sage
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