Need help invoking post method in Power BI Report

[rajeshchawla]

I'd like to create a Power BI button that invokes a POST method on a REST api. For the button, I've only been able to do a 'GET' call via the WEB URL action. 

Any thoughts or alternatives on how to invoke a POST method ?

[SofBL]

Hello @rajeshchawla I'v recently seen Daniel Sanders on pbig.nl summit, from https://plainwater.nl/ he created a function app that converts a get request into a post request. It has some limitations for instance the importance of security, and he warns for that. Secondly if you want to do a datarefresh by pushing a buton, you might try power automate or logic app https://www.process.st/how-to/refresh-power-bi-dataset-using-power-automate/

[Santhoshyeravel]

@rajeshchawla

I am also stuck with same use case can you help if you solution for this 

[v-stephen-msft]

Hi @rajeshchawla ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Stephen Tao

[rajeshchawla]

I see from your post how to invoke POST methods via M. However, I don't see how this would solve the use case of invoking a POST method as a button action on a report. Perhaps I'm missing something ?

[v-stephen-msft]

Hi @rajeshchawla ,

I found these posts might be helpful to solve your issue, please kindly refer to:

Post Method in Power BI
How to run POST request in M?
Using a REST API as a data source - POST Method Only

Best Regards,

Stephen Tao

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

[amitchandak]

@rajeshchawla , refer if these can help

https://www.thebiccountant.com/2018/06/05/easy-post-requests-with-power-bi-and-power-query-using-jso...

https://community.powerbi.com/t5/Desktop/Pull-data-from-API-using-POST-method-in-Power-BI/td-p/57472...

[rajeshchawla]

Thank you for taking the time. I see from your post how to invoke POST methods via M / PowerQuery. However, I don't see how this would solve the use case of invoking a POST method as a button action on a report. Perhaps I'm missing something ?