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

Connect to Webservice

Hi all,

 

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

 

 

5 REPLIES 5
Highlighted
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!




Highlighted
Community Support
Community Support

Hi @ls440 ,

 

Which Webservice Endpoint?

 

 

Best Regards,

Icey

Highlighted

for ex: SOAP 

Highlighted
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.

Highlighted

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? 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors