cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Connect to Webservice

Hi all,

 

How can I send data and Get data from Webservice Endpoint? 

 

 

5 REPLIES 5
Community Support
Community Support

Hi @ls440 ,

 

Which Webservice Endpoint?

 

 

Best Regards,

Icey

for ex: SOAP 

Community Support
Community Support

Hi @ls440 ,

 

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? 

Super User IV
Super User IV

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

 

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors