Forum Discussion
If power bi dataset schedule refresh failed than report builder report email subscription failed?
If power bi dataset schedule refresh failed than report builder report email subscription failed? We want when our dataset schedule refresh failed we want automatically their report subscription will be cancel till next successful refresh done. How we do that in power BI.
Hi Khushbu3
You would have to do this then using the Power BI REST APIs.
You would have to check the Power BI Refresh History with this API
Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
I would also change the report subscription to not be timed but rather to use Power Automate that once the dataset is refreshed to then send the report subscription.
1 Reply
- GilbertQ
Super User
Hi Khushbu3
You would have to do this then using the Power BI REST APIs.
You would have to check the Power BI Refresh History with this API
Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
I would also change the report subscription to not be timed but rather to use Power Automate that once the dataset is refreshed to then send the report subscription.