Forum Discussion
Manal
10 years agoRegular Visitor
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...
Anonymous
6 years agoNot applicable
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
XmlContentAmmey
3 years agoRegular Visitor
Hi
I'm facing the same issue. Could you please share the solution?