Kevin H on 15 Jul 2019 08:06:31
If we trigger a dataset refresh using the Power BI REST API, and that refresh fails, we need a way to send the email notification to many users.
Like described here:
https://powerbi.microsoft.com/en-us/blog/sending-refresh-notifications-to-others/
- Comments (1)
RE: Email Notification for Many Users, for Failed Dataset Refresh via REST API
I second this.
Although there is the option to pull the dataset refresh history status (https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistoryingroup) to programmatically check for failed refreshes, we would also prefer a push notification option instead. Mainly because it's hard to predict the frequency for checking the status and we don't now how long we should keep checking it.
In the meantime we will probably use the API endpoint for updating the refresh schedule (https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updaterefreshscheduleingroup) as a (unsatisfying) workaround by setting the schedule to "next half/full hour from now" after every successfull run for processing data in our data warehouse. This seems like the only way to get refresh notifications for triggered refreshes to multiple users in a convenient way somehow.