Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Getting SOAP with Credentials via From Web Connector

  • 1.  Getting SOAP with Credentials via From Web Connector

    Bronze Contributor
    Posted Nov 19, 2020 02:38 PM
      |   view attached

    Hi

    I have built a simple .Net SOAP web service (.asmx).  To use the web service you need to pass a Username and Password in the Header of the request.  I thought the best Connector to use in Power BI to consume this web service would be From Web.  I have:

    1) Given it the URL
    2) Selected Advanced
    3) Added Username and Password as parameters in the Header section
    4) See attached screen shot of how it looks

    It doesnt seem to connect. 

    I tried it via Postman and it works fine but I pass the below in the BODY.  I noticed Power BI does not allow me to pass anything via the BODY and only the HEADER

    <?xml version="1.0" encoding="utf-8"?>
    <soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
    <soap12:Header>
    <HeaderCredentials xmlns="http://tempuri.org/">
    <Username>MyUser</Username>
    <Password>MyPassword</Password>
    </HeaderCredentials>
    </soap12:Header>
    <soap12:Body>
    <GetTimeLogger xmlns="http://tempuri.org/" />
    </soap12:Body>
    </soap12:Envelope>

    Am i using teh correct Power BI Connector

    Any help would be greatly appreciated

    IG



  • 2.  RE: Getting SOAP with Credentials via From Web Connector

    Posted 24 days ago
    You managed to solve it?, I am having the same problem when sending parameters

    ------------------------------
    John Doe
    ------------------------------