Forum Discussion

Guna's avatar
Guna
Frequent Visitor
2 years ago
Solved

API to trigger the report subscriptions on Demand

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 o...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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