API Button action on Power BI

[sribmc]

Hi Team,

I have API that needs to be triggered based on fields selected on filter and when I click on submit it need to pass parameters selected from filters and output response will need to be visible in tabular format  below of submit button on same page.

Please help me with solution ASAP.

[Anonymous · Accepted solution]

Hi @sribmc ,
Based on your description, you can use a combination of Power BI buttons, Power Automate, and custom visual objects. First you can create buttons that operate Power Automate streams, then set up a Power Automate stream and format the API. Then you need to configure the button to operate the buttonClicked event. Finally, bind the analyzed data from the Power Automate stream to the table visual object.
You can view the following documentation for details on how to do this
Take action from ‘Button clicked’ in Power BI Embedded | Azure updates | Microsoft Azure
Create buttons in Power BI reports - Power BI | Microsoft Learn
How to handle events in a Power BI embedded analytics application | Microsoft Learn

Best regards,
Albert He

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