Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

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) ...

Need Help

Icey
7 years ago
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.

MrSan

New Member

6 years ago

Hello,

Any chance do you show us how are you connecting Power BI with the SOAP API?

Anonymous
Not applicable
6 years ago
Hey MrSan

I used the answer from dataloreous in the below link
https://community.powerbi.com/t5/Desktop/How-to-get-data-from-a-SOAP-WS-with-Power-BI/td-p/29040

I used the below with the code, with the xml body stored in an XML file

let
Source = Xml.Tables(Web.Contents("API WEB PAGE",[Content=File.Contents("XML FILE LOCATION"),Headers=[#"Accept-Encoding"="gzip,deflate", SOAPAction="", #"Content-Type"="text/xml;charset=UTF-8"]])),

Forum Discussion

XML to table - seperate columns and rows

Related content

Model composite with seperate table

How to export table multiple columns into one column with ; seperator (csv format)

Periods seperation

Index match custom column from seperate table

Direct Lake Model - Calculated Column/Tables