Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |