Forum Discussion

Manal's avatar
Manal
Regular Visitor
10 years ago

How to get data from a SOAP WS with Power BI

Hello,   I have an application with a SOAP wb and I want to create Dashboards using Power BI Desktop. How do I get data using the SOAP wb ?  I know that Power BI has a REST API and it says that i...
Need Help
Yggdrasill's avatar
Yggdrasill
Icon for Responsive Resident rankResponsive Resident
6 years ago

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)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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
  • juliovidigal's avatar
    juliovidigal
    Icon for Advocate I rankAdvocate I
    6 years ago

    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

  • SwagatikaBehera's avatar
    SwagatikaBehera
    Frequent Visitor
    5 years ago

    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?

  • Ammey's avatar
    Ammey
    Regular Visitor
    3 years ago

    Hi 

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

  • Ammey's avatar
    Ammey
    Regular Visitor
    3 years ago

    Hi 

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