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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
Super User
Super User

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors