Forum Discussion
Solved
How to Make Data Activator Trigger Only Once Per Day Without Modifying Power BI?
Hi Fabric Community, We have a Power BI dashboard that tracks error counts, and we want to set up Data Activator to trigger an alert only once per day when errors occur. However, our Power BI data...
ā Resolved
Thanks for the suggestions! Just to clarify for anyone facing a similar issue - the solution wasn't based on adjusting the 3600-second trigger interval in Data Activator.
Instead, we handled it by enhancing the Power BI logic itself. We introduced conditions to check:
- Whether a ticket already exists (to avoid duplicate alerts), and
- Whether the dashboard refresh time in UTC had changed (to ensure alerts are only triggered once).
By combining these checks along with few more conditions in Power BI columns & then adding it to Activator, we were able to control the alert frequency effectively and ensure Data Activator only triggers as per need, regardless of how often the dataset refreshes.
Hope this helps others working through similar scenarios!
Your requirement is incompatible with the idea of a trigger.
If you need a scheduled report, create a scheduled report.