How to get data from a SOAP WS with Power BI

Like a few of the others, I am also having an issue where I just end up with this

and I'm not sure how to troubleshoot.  Can anyone assist?

let
    SourceURL = "http://soap.proofhq.com/19_2_6/soap.wsdl",

options = [ #"Accept-Encoding"= "gzip,deflate",
           // SOAPAction="", 
            #"Content-Type"="text/xml;charset=UTF-8",
            #"Connection"="Keep-Alive"
          ],
WebContent = Web.Contents(SourceURL, 
// Content options in Web.Contents() requires you to authenticate anonymously ! 
    [Content=Text.ToBinary("
    <?xml version='1.0' encoding='UTF-8'?>
   <soapenv:Envelope xmlns:soapenv=#(0022)http://schemas.xmlsoap.org/soap/envelope/#(0022) xmlns:soap=#(0022)https://soap.proofhq.com/#(0022)>
   <soapenv:Header/>
   <soapenv:Body>
      <soap:doLogin>
         <Login>[email protected]</Login>
         <Password>jy@%MZdI#O7gikwl23dKI@IG9!5W</Password>
         <Subdomain>mysubdomain</Subdomain>
      </soap:doLogin>
   </soapenv:Body>
</soapenv:Envelope>
"), 
Headers=options]) ,
XmlContent = Xml.Tables(WebContent)
in
    XmlContent

I am not using #022 in soap UI and also I made this by review previous posts and they are not using this.

As Anonymous mentions, you need to replace the quote marks " from the SOAP UI envelope to #(0022) like so:

<?xml version="1.0"?>

-<soapenv:Envelope xmlns:soap=#(0022)http://soap.severa.com/#(0022) xmlns:ns1=#(0022)http://soap.severa.com/#(0022) xmlns:soapenv=#(0022)http://schemas.xmlsoap.org/soap/envelope/#(0022)>-<soapenv:Header>

<ns1:WebServicePassword>Api Token Key</ns1:WebServicePassword>

</soapenv:Header>-

  <soapenv:Body>-

    <soap:GetHourEntriesByDate>

      <soap:startdate>2020-04-12T09:00:00</soap:startdate>

<!--Optional:--></soap:GetHourEntriesByDate>

</soapenv:Body>

</soapenv:Envelope>

If you can connect via SOAP UI and not Power BI, you're doing something wrong in the PQ (advanced editor)

Good Morning.
What should your output be?

In the ones I did in the past, I always used XML.Tables ....

let

Source = Xml.Tables(Web.Contents("https://advertising.criteo.com/API/v201305/AdvertiserService.asmx?WSDL"

,[Content=Text.ToBinary("<soapenv:Envelope xmlns="&Character.FromNumber(34)&"https://advertising.criteo.com/API/v201305"&Character.FromNumber(34)&" xmlns:soapenv="&Character.FromNumber(34)&"http://schemas.xmlsoap.org/soap/envelope/"&Character.FromNumber(34)&">

<soapenv:Body>

<clientLogin>

<username>[email protected]</username>

<password>aaaaaaaa</password>

</clientLogin>

</soapenv:Body>

</soapenv:Envelope>"),Headers=[#"Accept-Encoding"="gzip,deflate", #"Content-Type"="text/xml;charset=UTF-8"]]))

in

Source

Hi,

I am new to Power BI and also looking for how to get data from SOAP based WCF services in PowerBI. I am able to get the data using ZappySys xml driver. Can you please provide me screenshots how to achieve without using xml driver?

Hi 

I'm facing the same issue. Could you please share the solution?

Hi 

I'm facing the same issue. Could you please share the solution?