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
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.
Solved! Go to 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
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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.