Forum Discussion
Create Two Data Alerts
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 |
2 Replies
- lbendlinSuper User
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.
- v-chenwuz-msftCommunity Support
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.