Forum Discussion

roysampad91's avatar
roysampad91
Frequent Visitor
2 years ago

Trigger an M Query on a button click on Power BI

I am trying to "POST" to a REST API and have achieved it via M Query. Could anyone please help on how to trigger the M Query on a button click on Power BI?

Need Help

3 Replies

  • Sergii24's avatar
    Sergii24
    Icon for Super User rankSuper User
    2 years ago

    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! 

  • roysampad91's avatar
    roysampad91
    Frequent Visitor
    2 years ago

    this is my M query and it's doing what is expected however want to parameterise the body and trigger it on a button click.  Need help to understand how to achieve the same?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi roysampad91 

       

      Currently the native button in a Power BI report cannot trigger a Power Query M query. Because PowerQuery is used for data ETL, and the buttons in the report are added when making the report. Reporting happens after the data ETL, so there is no way to use a button to trigger an action that should happen before.

       

      May I know why you want to trigger it on a button click? Do you hope that report users can use the button to trigger the query? If so, this is not supported for the reason above.

       

      You may explore Power Automate to create a flow to trigger a POST request but you have to store the data received to somewhere else out of Power BI. The data received cannot be loaded into the same PBI report where the trigger-flow button is.

       

      Hope these explanations help. 

       

      Best Regards,
      Jing
      If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!