Forum Discussion
XML to table - seperate columns and rows
I have succesfully run a Soap API call to retrieve XML data however I am unable to parse the data into readable tables due to the column names data being seperate from the row data (as per below)
The below screenshot is as far as I get - as when I expand the "Row" column it duplicates every item
After expanding twice. As you can see the second column doesnt match the first column
Hi Anonymous ,
Maybe you can refer to this post: Expand Column Containing Some Tables and this blog: Expanding All Columns In A Table In Power Query.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- Icey
Community Support
Hi Anonymous ,
Maybe you can refer to this post: Expand Column Containing Some Tables and this blog: Expanding All Columns In A Table In Power Query.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Any chance do you show us how are you connecting Power BI with the SOAP API?
- Icey
Hi Anonymous ,
Is this problem sloved?If it is sloved, could you kindly accept it as a solution to close this case?If not, please let me know.Best RegardsIceyHi Icey although it looks like some variation of the answers in your links could work, I was unable to manipulate their work to solve mine
In the end I expanded only one side of the tables, pivotted and added new columns to match the column names I didnt expand
I will mark your reply as solved though as I suspect the issue is with my lack of power BI knowledge
