Trigger an M Query on a button click on Power BI

Hi roysampad91, could you tell more on how you've managed to make "post" request with M language of Power Query? As of my knowledge PowerQuery is used for data transofrmation only, so I'm curious to know how you managed to create a post request.

However, to launch an action from directly from PowerBI report you can use "Power Automate visual" and create Power Automate flow that will perform necessary actions (including post htttps reqeust). You can learn more about it in this video and Microsoft documentation - Create a Power Automate visual for Power BI - Power BI | Microsoft Learn

Good luck with your project!