Connect to Webservice

[Anonymous]

Hi all,

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

[Icey]

Hi @Anonymous ,

Which Webservice Endpoint?

Best Regards,

Icey

[Anonymous]

for ex: SOAP 

[Icey]

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.

[Anonymous]

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? 

[Greg_Deckler]

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