Is this possible to have api call in view report button action

[JosephKingston]

Hi,

I have paginated report with View Repot button. As of now, on click of the view report which calls the stored procedure and result is shown in this UI page.

Is this possible trigger api call on click of the View Report button before stored procedure call?

1, API call will populate data in Manager table in db
2, Then the stored procedure call will be made to pull the data from the Manager table.
3, Populate in UI. 

Thanks in Advance.

[Anonymous]

Hi @JosephKingston ,

Currently, Power BI paginated reports primarily support data retrieval through direct queries or stored procedures specified in the report's data source settings. The direct invocation of an external API to manipulate database tables before executing a stored procedure is not a built-in feature of Power BI paginated reports. 

There are some suggested methods for you to consider.

Use Power Automate to create a flow that triggers the Azure Function and then refreshes the Power BI dataset or directly triggers the paginated report. Power Automate can provide a URL that, when accessed, executes the flow.

Best Regards,

Neeko Tang

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