Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello, I have a problem with importing this xml file,
I don't know why but when I tried to upload the xml file, the file looks like a bunch of tables like in the photo above. Then, I tried to expand the data in Power Query Editor and resulted like this:
The data doesn't seem to correspond to the exact column. For example, Aruba and 1960 should be in different columns. This is what the xml file looks like when I opened it in a browser:
Does anyone know how to fix this?
Solved! Go to Solution.
NewStep=#table(4,List.Split(PreviousStepName[#"field.Element:Text"],4))
try to replace the code here with this
=Table.Combine(List.Transform(Table1[field],each Table.AddColumn(#table([#"Attribute:name],{[#"Element:Text"]}),"key",(x)=>Text.Combine([#"Attribute:key"]," - "))))
That still didn't work. But now I think I just transformed the data into like this:
So I just need to turn every 4 rows into just one row. For example, the first row should be Aruba in the first column, Government expenditure...... in the second column, 1960 in the third column, and null in the fourth column. Does anyone know how to do that? I would really appreciate it.
NewStep=#table(4,List.Split(PreviousStepName[#"field.Element:Text"],4))
It worked! Thank you so much.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |