Forum Discussion
Refresh Date Alerts
Hi everyone,
I'm looking for a way to set up alerts for the refresh date. Basically setting up alerts for datasets out of date. I already set up the refresh schedule.
Could someone tell me how to do that if it's even possible?
Thanks
- Hi there
What you could do, is to download the refresh history and then based on the refresh schedule see if it is up to date.
Here is the API that you can use: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistory
You would then have to download this data and then check this against your source. Hi alkanet
So you would like to send a notification to users when data gets refreshed?
There is Data alert feature, but it is not for data refresh notification, but for the data threshold alert. See Data alerts in Power BI service.
There is also a subscription feature, I think it may “partly” realize your request. Once the data gets refreshed for the first time in a day, Power BI will email to subscribers (Noted Users have to subscribe the report themselves. ) See https://powerbi.microsoft.com/en-us/guided-learning/powerbi-service-subscribe-to-report/
Here is a relative thread: https://community.powerbi.com/t5/Service/Scheduled-Refresh-notifications/td-p/290721
You could also vote for this Power BI idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18487522-alert
3 Replies
- Hi there
What you could do, is to download the refresh history and then based on the refresh schedule see if it is up to date.
Here is the API that you can use: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistory
You would then have to download this data and then check this against your source. Hi alkanet
So you would like to send a notification to users when data gets refreshed?
There is Data alert feature, but it is not for data refresh notification, but for the data threshold alert. See Data alerts in Power BI service.
There is also a subscription feature, I think it may “partly” realize your request. Once the data gets refreshed for the first time in a day, Power BI will email to subscribers (Noted Users have to subscribe the report themselves. ) See https://powerbi.microsoft.com/en-us/guided-learning/powerbi-service-subscribe-to-report/
Here is a relative thread: https://community.powerbi.com/t5/Service/Scheduled-Refresh-notifications/td-p/290721
You could also vote for this Power BI idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18487522-alert
Hi there,
Thanks for both replies, I will take a look to find out what the best way is.
