Say I have a Power BI dataset with a datetime column, "DateTimeX," the values of which are in UTC. And, the dataset is refreshed every 4 hours in the Power BI Service.
Is there some way to have Power BI notify me when the "most recent value of DateTimeX" is, say, more than 5 hours old?
What I thought I might do:
- Create an "Age of Latest Data" measure to show how old my data is:
Age of Latest Data = UTCNOW() - MAX(DateTimeX) - Create a report, with just one "Card" visualization, showing Age of Latest Data; and pin that Card to a dashboard
- Create a data alert to notify me when "Age of Latest Data" > 5 hours
However, I read that "Alerts only work on data that is refreshed. When data refreshes, Power BI looks to see if an alert is set for that data. If the data has reached an alert threshold, an alert is triggered."
Instead, I want to be notified as soon as "Age of Latest Data" > 5 hours ... including between data refreshes.
So, I don't think I can do this with the "data alert" functionality.
Is there any other way to do this? To have Power BI give me some kind of notification, as soon as "Age of Latest Data" > 5 hours?
