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.
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.