Convert XML data into a table

Question

Hi everyone,&nbsp;My dashboard is connected with a Web Service API via POST method and the output is XML. However, the I'm getting is scattered over multiple rows instead of being on the same row for a particular user.&nbsp;My current Query is as below:let&nbsp; &nbsp; //Insert API key here&nbsp; &nbsp; apiKey = "######",&nbsp; &nbsp; //Web Services url&nbsp; &nbsp; url = "######",&nbsp; &nbsp; //Company Name&nbsp; &nbsp; CompanyText = "ABCompany",&nbsp; &nbsp; //Add the text "company=" to the beginning&nbsp; &nbsp; CompanyName = "company=" &amp; CompanyText,&nbsp; &nbsp; //Call the web service&nbsp; &nbsp; Source = Table.FromColumns({&nbsp; &nbsp; &nbsp; &nbsp; Lines.FromBinary(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Web.Contents(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; url&nbsp;&amp; apiKey,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Content=Text.ToBinary(CompanyName)])&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; })in&nbsp; &nbsp; Source&nbsp;I would like the output to be a table like this:&nbsp;&nbsp;Would really appreciate your help!

v-xicai · Accepted Answer

Hi Anonymous&nbsp;,&nbsp;You may click Parse to xml&nbsp;and expand the table.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;You can refer to the similar case to get detail steps:https://community.powerbi.com/t5/Desktop/convert-XML-query-to-a-table/td-p/628011.&nbsp;Best Regards,Amy&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Convert XML data into a table

2 Replies

Related content

Convert jotfom data to table

Convert Dynamic Data source

Converting JSON data into PowerBI table

Converting a Table

Converting XML data to a table