Emailing users when refreshed data changes

[RGI]

I need to be able to email users when the dataset is refreshed with new data.

The problem I have is that emails are sent out after the first refresh of the day regardless of whether the underlying data has changed.

Sometimes the ETL processes feeding in new data fail, and under these situations I don't want to email the users after a "false" refresh.

[Greg_Deckler]

So here is one method. Create a measure that is count of rows of some fact table that you have using COUNTROWS. Display this measure in a Card tile on a dashboard. Use the ellipses (...) of the tile to Manage alerts. Set an alert for a number you know is well below how many rows are in the table. Alerts will only be sent when the data changes.