View My Drafts
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 URL2) Selected Advanced3) Added Username and Password as parameters in the Header section4) See attached screen shot of how it looksIt 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 ConnectorAny help would be greatly appreciatedIG