If we can refresh dataset in 30 min then we should be able to trigger the alert in 30 min.

[GilbertQ]

Hi @gauravk 

You can vote or create an idea at https://ideas.powerbi.com

Or what you could do is to use Power Automate and a DAX measure to alert you when there is an issue which you could run every 30 mins?

[gauravk]

Thanks @GilbertQ for replying. If you could help me in how to use Power Automate and a DAX measure to alert if I am refreshing my data in every 30 min. 

[GilbertQ · Accepted solution]

Hi @gauravk 

You would need to create a DAX measure which would return data to alert you if there is an issue. Typically you would create a measure that would return a 1 (if there is an issue) or 0 (if it is all good and no issue)

Next you can use Power Automate to run the DAX  measure against the dataset and then based on those conditions you could then send an email.

This link below explains how to run the DAX measure/query against a dataset.

Emailing Power BI Query output as a CSV Files using Power Automate - FourMoo | Power BI | Data Analy...

[gauravk]

Thanks it worked.