Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Guna
Frequent Visitor

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 outdated data. In such scenarios, we need to trigger all the subscriptions on demand.

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
v-heq-msft
Community Support
Community Support

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
Solution Sage
Solution Sage

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 

Helpful resources

Announcements
Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.