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
juliovidigal's avatar
juliovidigal
Icon for Advocate I rankAdvocate I
7 years ago

Inside the Text.ToBinary it plays the role of ".
Mine works with this, you can use it ... even because it's so much better than using the dento call of a file, it's all in the code.

Jonas1's avatar
Jonas1
Icon for Helper I rankHelper I
7 years ago

I tried running the API in Postman to see if there could be anything wrong with my M, but I am getting Status code 401 there as well, so I think it is my credentials it is something wrong with. I will try to run it through the provider of the API. 

 

Thanks for your time though juliovidigal , will make sure to try it out as soon as my crediantial problems has been dealt with. 

  • Jonas1's avatar
    Jonas1
    Icon for Helper I rankHelper I
    7 years ago

    Hey juliovidigal ,

     

    So I finally managed to get the session ID (token) in Postman, but I think it is gonna be hard to get it to work in Power BI alone. What gets challenging is that it actually requires me to authenticate twice when doing the session ID call. Once in the XML, but also under authorization in Postman using a different username (or in request properties if you are more familiar with ReadyAPI). 

     

    As far as I can see you then have to apply basic authorization in Power BI as well, which is not allowed when using Content in a Web.Content expression.... I guess you were able to create a anonymous connection in Power BI?