Forum Discussion
How to get data from a SOAP WS with Power BI
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?