Forum Discussion

mikey_m's avatar
mikey_m
Regular Visitor
8 years ago

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 ...
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

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

  • mikey_m's avatar
    mikey_m
    Regular Visitor
    8 years ago

    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?

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      8 years ago

      Hi mikey_m，

       

      I'm sorry for my mistakes.  

       

      Hope this blog can help you.

       

      Besides, you also could have a look at this video.

       

      Best Regards,

      Cherry

      • mikey_m's avatar
        mikey_m
        Regular Visitor
        8 years ago

        Yes we've seen that blog, seems to make sence if you have a service that can convert SOAP to OData.

         

        In the meantime, SOAP does not seem supported as a default web source.

         

        We've tried teh ZappySys - despit being able to connect to the WDSL OK, it cannot parse the data and errors out.