API to trigger the report subscriptions on Demand

[Guna]

Is there a programmatic way to trigger the list of subscriptions in a report all at once?

Sometimes, the upstream system takes time to refresh, causing scheduled subscriptions to be triggered with outdated data. In such scenarios, we need to trigger all the subscriptions on demand.

[v-heq-msft · Accepted solution]

Hi @Guna ,
Thanks to @SaiTejaTalasila  reply. Here is what i want to add:
Based on your description, Power BI doesn't provide a direct API specifically designed to trigger report subscriptions on demand. Subscriptions are primarily designed to be triggered based on a predefined schedule or when a data refresh is complete. However, you can programmatically trigger a dataset refresh using the Power BI REST API. Once the dataset is refreshed, any subscriptions that are set to trigger "After Data Refresh" will be sent. This ensures that the most up-to-date data is used to trigger the subscription. Or you use Power Automate, as @SaiTejaTalasila  said, to create a flow that triggers a dataset refresh and then waits for a specified duration before sending a custom notification or report. While this doesn't directly trigger the built-in Power BI subscription, it allows for a degree of automation and customization in how and when reports are distributed.
Here are some documents you can refer to
Official Microsoft Power Automate documentation - Power Automate | Microsoft Learn
Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | 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

[SaiTejaTalasila]

Hi @Guna ,

As per my knowledge you can't.If you want to send somesnaps or pdf file of your report you can do that with power automate.

Thanks,

Sai Teja