Power BI
Needs VotesEmail Notification for Many Users, for Failed Dataset Refresh via REST API
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 (3)
RE: Email Notification for Many Users, for Failed Dataset Refresh via REST API
Will be great to have this feature,,
RE: Email Notification for Many Users, for Failed Dataset Refresh via REST API
There should be a way to set a notification on a dataset that will notify users when a refresh fails, no matter how it is refreshed. You refresh manually, you don't know it fails unless you keep checking on it. You have an API refreshing through MS Flow and you get no notifications. Even a trigger on the completion of failure the dataset they you could create a flow on would help.
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.