Forum Discussion
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...
JasonL
Advocate II
Advocate IIHi,
I think we found somehting :
we created an XML file (poste.xml) with the info for the SOAP web service :
then in the advanced editor of the query editor we add the path to the file :
let
Source = Xml.Tables(Web.Contents("URLofthewebservice",[Content=File.Contents("C:\Users\username\Desktop\XX\post.xml"),Headers=[#"Accept-Encoding"="gzip,deflate", SOAPAction="", #"Content-Type"="text/xml;charset=UTF-8"]])),
previously we used "get data" --"web"---- URLofthewebservice. you drill down untill you get a table, you can either load or modify the query.