Forum Discussion
How to get data from a SOAP WS with Power BI
Community ChampionWell, the world has kind of moved on from SOAP and to my knowledge there is not any SOAP accessor function in Power Query:
https://msdn.microsoft.com/en-us/library/mt296615.aspx
A couple thoughts I had, use an ODBC driver for SOAP such as here:
http://www.drdobbs.com/windows/odbc-driver-development/184416434
The other thought that I had was a SOAP to OData proxy but I really can't find one out there, all I could find was how to convert from SOAP to OData:
http://www.codeproject.com/Articles/590627/Converting-SOAP-based-WCF-Service-to-RESTful-Desig
On a personal note, I am not sorry to see SOAP go away, it was seemed like a terribly costly data protocol in terms of overhead and I always stuck with RESTful services. I have a general idea that my feelings were shared by the majority of people out there and hence why SOAP has largely gone away.
Thank you!
After some more researches I found this : https://www.dreamfactory.com/content/turn-soap-rest
It seems like DreamFactory can turn a SOAP into REST WS. I will test it and see if it does work for me.
Hi Manal,
I'am wondering if the DreamFactory approach worked? Cloud you share your experiences?
Greetings,
Ronald
Any recommendation to parse XML query from a server? in my use case I should send date time range to the server and request back the data from the server.
