Query RestAPI with POST

[shocko]

I have a RestAPI that returns data but requires a GET to some endpoints and a POST to others. Can PowerBI send HTTP POST to a Web Data or OData data source?

[v-lionel-msft · Accepted solution]

Hi @shocko ,

Yes, you can achieve it, please refer to this:

Web Services And POST Requests In Power Query 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shocko]

Thanks for the link! Is there anywhere to raise feature requests for PowerBI. Obstensibly one would think we should be able to do this within the web connector UI natively? 

[v-lionel-msft]

Hi @shocko ,

You mean changing the HTTP request method in the UI interface of the web connector?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shocko]

Yes, there does not appear to be an option to set method to POST here. 

[blopez11]

Yes, you can force an HTTP post by using the Content parameter of Web.Contents, please see https://docs.microsoft.com/en-us/powerquery-m/web-contents

Good luck,

[blopez11]

You can take a look at the following for further reference: https://community.powerbi.com/t5/Desktop/How-to-run-POST-request-in-M/td-p/457138