Create Two Data Alerts

[PBInewbie17]

I want to create two separate data alerts that will be used to trigger automated emails to employees depending on the number of days they have to meet their project deadline. The data alerts must meet the following criteria:

• Alert 1: Data alert to email Certified employees with exactly 30 days until project deadline. I realize data alerts must be above or below a numerical threshold, so how can I measure this?
• Alert 2: Data alert to email Certified employees with an Overdue project status (i.e., negative days until deadline). Once the data alert meets the criteria of having a negative number of days, is there a way to prevent the alert from triggering the overdue items twice? The dataset will be refreshed every day, and I don't want the alert for overdue items to be triggered every single day, only once.

Employee	Certification	Project Deadline	Days Until Deadline	Status
Amy	Uncertified	4/29/2020	-651	Overdue
Sara	Certified	12/4/2021	-67	Overdue
Xavier	Certified	2/9/2022	0	In Process
John	Certified	3/10/2022	29	In Process
Brittany	Certified	3/11/2022	30	In Process
Demetri	Certified	3/12/2022	31	In Process
Mark	Certified	3/15/2022	34	In Process
Paul	Certified	4/6/2022	56	In Process
Quintoya	Uncertified	6/1/2022	112	In Process
Ravi	Uncertified	5/13/2025	1,189	In Process

 

[v-chenwuz-msft]

Hi @PBInewbie17 ,

Maybe you can try Power bi Goals work with Power Automate to sent email. 

As far as I know, in power bi you can only send alerts for each employee by creating multiple gauges. And alerts are sent out every time the data is refreshed. 

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Use an external process based on Powershell or other tools that calls the Dataset queries API.

Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Docs

That gives you the most flexibility.