Forum Discussion
Pull in Data from SOAP
Hey Guys
Not at all going to pretend that I know what I'm doing, I do not.
The sales stuff seems to show Power BI as a great analytics tool especially the capability to pull in multiple data sources. before we sign up a few users, we're testing a bit here and there.
A SQL connection seems easy enough, we know table layouts and can find data for queries etc.
However, we have several SOAP API's for systems that we use. Yes it's still used out there and many will argue black and blue which is better. We dont care, the vendors give us what we get, thats SOAP.
We've seen the thread on here - https://community.powerbi.com/t5/Desktop/How-to-get-data-from-a-SOAP-WS-with-Power-BI/td-p/29040 but it's beyond our skill set.
We have been able to make some queries work via Ready API, so we're heading the right direction we think.
So: Should we keep trying to make this weird XML hybrid work? or should we look to get a SOAP to REST converter to make life easier?
Your advice is greatly appreciated.
Cheers Mike
7 Replies
Anyone ???
Hi mikey_m,
We've seen the thread on here - https://community.powerbi.com/t5/Desktop/How-to-get-data-from-a-SOAP-WS-with-Power-BI/td-p/29040 but it's beyond our skill set.
We have been able to make some queries work via Ready API, so we're heading the right direction we think.
What data type do the queries return? JSON or others? And what Authentication do you use? Basic , OAuth or others?
Besides, I suggest you could use web connector in Power BI to get data which way should be easier.
For further, you could have a good look at this blog about how to get data from API with different ways. You could choose one way which is suitable for your scenario.
Best Regards,
Cherry
Today we tried the Apigee.com SOAP - REST - SOAP coud adapter, but we cannot authenticate the session through it.
We would love to use Web however (As I understand it) thats for REST and we cannot pull REST out of our API we can only pull out via SOAP.
We're simply wanting to pull tables and fields out so we can report on them.
Which Blog do you refer to?
