Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
How can I send data and Get data from Webservice Endpoint?
Hi @Anonymous ,
Which Webservice Endpoint?
Best Regards,
Icey
for ex: SOAP
Hi @Anonymous ,
There is no official connector for SOAP in Power BI. For workarounds, you can refer to these posts:
How to connect SOAP API to Power BI;
How to get data from a SOAP WS with Power BI.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is it possible the data from the database is pushed or pulled into an intermediary layer from where Power BI can access it, with out having access to our database? Also can we incrementally update the data in this intermediary layer, so we don't have to pull data for past years every time we update or add data?
Well, if the endpoint returns XML, use that connector, if it returns JSON, use the JSON connector. ODATA... Dynamics 365 has a web service endpoint, you use the Dynamics connector for that. Going to depend on the endpoint but there are lots of options. You can even use R or Python if your prefer:
https://docs.microsoft.com/en-us/powerquery-m/accessing-data-functions
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.