How to get data from a SOAP WS with Power BI

Hi all,

I am getting the following error.

DataFormat.Error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: The 'link' start tag on line 31 position 6 does not match the end tag of 'head'. Line 80, position 3.)
Details:
    Binary

Here is my Advanced Editor code:

let
    Source = Xml.Tables(Web.Contents("https://sandbox......./", [Content=File.Contents("C:\Users\....\get_default.xml"),Headers=[Authorization="Bearer 34653fdsgfdsffd", #"Content-Type"="text/xml", SOAPAction="http://....../get.........Details"]]))
in
    Source

Here is my Xml code:

<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/' xmlns:ins='http://beans....._v3'>
  <soapenv:Header/>
  <soapenv:Body>
  <ins:removedforprivacy>
  <startDate>2012-10-17</startDate>
  <endDate>2012-10-22</endDate>
  <pagingInfo>
  <pageNumber>0</pageNumber>
  <pageSize>5</pageSize>
  </pagingInfo>
  </ins:removedforprivacy>
 </soapenv:Body> 
</soapenv:Envelope>

This code works in R using RCurl, I have also tried it with the addition of <?xml version="1.0"?> at the start. I also tried it using the Content=Text.ToBinary(".....").

Could the issue be with the file being returned?

Thank you

:)

 Edit 1: grammar etc.

Edit 2: The issue was the the main url - the inititial url used to set up the web access and a secondary used in the advanced editor.  This was followed up by another issue where the data would not be loaded out of the query editor... This was solved by making sure the page size fit the data limit.