Forum Discussion

Manal's avatar
Manal
Regular Visitor
10 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Have you tried to get data with SOAP UI or POSTMAN software?

If it is OK - then I recommend to watch carefully for the headers in POST metod.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes its working in SOAP UI and I have created above mentioned xml and query by following this thread.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Then it should work.

    I had a trouble in some unnoticable things - like conncetion string ending...

     

    Also I do not see that in your XML you use #(0022)  instead of " . See my example below - may the trouble in it.

     

    body="<soapenv:Envelope xmlns:soapenv=#(0022)http://schemas.xmlsoap.org/soap/envelope/#(0022)

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I am not using #022 in soap UI and also I made this by review previous posts and they are not using this.

      • Yggdrasill's avatar
        Yggdrasill
        Icon for Responsive Resident rankResponsive Resident
        6 years ago

        As Anonymous mentions, you need to replace the quote marks " from the SOAP UI envelope to #(0022) like so:

        <?xml version="1.0"?>

        -<soapenv:Envelope xmlns:soap=#(0022)http://soap.severa.com/#(0022) xmlns:ns1=#(0022)http://soap.severa.com/#(0022) xmlns:soapenv=#(0022)http://schemas.xmlsoap.org/soap/envelope/#(0022)>-<soapenv:Header>

        <ns1:WebServicePassword>Api Token Key</ns1:WebServicePassword>

        </soapenv:Header>-

          <soapenv:Body>-

            <soap:GetHourEntriesByDate>

         

              <soap:startdate>2020-04-12T09:00:00</soap:startdate>

        <!--Optional:--></soap:GetHourEntriesByDate>

        </soapenv:Body>

        </soapenv:Envelope>

         

         

        If you can connect via SOAP UI and not Power BI, you're doing something wrong in the PQ (advanced editor)