Forum Discussion
Activator Teams Alert
I've set alerts on multiple PBI service reports and none of them are firing. I've tried changing the conditions for the trigges but nothing seems to work. The alerts save, and are set, and the test alert goes through fine each time, but that's it. The alert is for whenever the value in a column contains "CRT3".
Hi JCSchuman,
Thank you for reaching out to the Microsoft Fabric Forum Community.
If the test alert works but the actual alert never fires, the issue is often related to using a text condition in the trigger. Alerts created through Activator on a Power BI report generally work more reliably when the condition is based on a numeric value. A practical workaround is to create a measure that converts the text check into a numeric flag (for example, return 1 when the column contains “CRT3” and 0 otherwise) and then configure the alert to trigger when the value is greater than 0. This helps Activator detect the condition properly during dataset refresh because the rule evaluates changes in numeric values.
Thanks & Regards,
Prasanna Kumar
3 Replies
Hi JCSchuman,
Thank you for reaching out to the Microsoft Fabric Forum Community.
If the test alert works but the actual alert never fires, the issue is often related to using a text condition in the trigger. Alerts created through Activator on a Power BI report generally work more reliably when the condition is based on a numeric value. A practical workaround is to create a measure that converts the text check into a numeric flag (for example, return 1 when the column contains “CRT3” and 0 otherwise) and then configure the alert to trigger when the value is greater than 0. This helps Activator detect the condition properly during dataset refresh because the rule evaluates changes in numeric values.
Thanks & Regards,
Prasanna Kumar
Hi JCSchuman,
Just following up to see if the Response provided was helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna KumarHi @JCSchuman,
Just following up to see if the Response provided was helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar