This feature would be really useful to have, SSIS has a good Web Service Task component for that. can we have something like web service source here in Power Query / Power BI?
PowerBI has a REST API that you can use to send information from your webservices or other sources.
Thanks, but I mean ability to give url of WSDL file or ASMX or web service url, and then pass parameters all in Power Query or Power BI Designer.
You should probably think of wrapping your web service as an OData feed instead. You should look at the WebApi samples from MSFT in GitHub.
Anyone got this working? I need to send a specific xml string (contains username, password, requested report name etc) to a webservice. How can this be done?
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.