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
hugoberry's avatar
hugoberry
Icon for Responsive Resident rankResponsive Resident
9 years ago

Text.Format would help you to store username password in some parameter and pass it to the XML builder routine. Something like this:


Text.Format("longxml

<username>#[username]</username>
<password>#[password]</password>
more xml",[username = parameter_username, password= parameter_password])

juliovidigal's avatar
juliovidigal
Icon for Advocate I rankAdvocate I
9 years ago

Thank you for the tip.
I will certainly use it in other scenarios. In this scenario, I only use username and password at that moment, then I use the Token that I get from this authentication, and that email and password will not change.

Thank you