Forum Discussion

saud968's avatar
saud968
Memorable Member
1 year ago
Solved

Data Activator Power BI Report Alert

I have created an alert if the condition is true for 6 hours, but I am still getting an alert every hour—any clue on how I can get this working as needed?

Ahmedxlbendlin rohit1991 

  • Hi saud968 ,
    Thanks for engaging with Fabric Community,

    Just to clarify, Data Activator checks conditions by default every hour and there is no way to change this frequency. So if the condition remains true, it can trigger an alert each hour during those checks.

    References:

    Power Bi visual alert frequency in Activator 
    Activator alert frequency 

     

    The “Time elapsed” setting means: How long Data Activator should wait before treating the condition as no longer true if no new data arrives.

    Time Elapsed 

     

    So in your setup:

    >The condition is being checked every hour. Since data is arriving regularly and the condition stays true, alerts are triggered each hour.

    >If you want to avoid repeated alerts, you might need to add some logic using Power Automate to limit how often alerts are sent.

     

    In a similar discussion, the suggested approach is to use a KQL Queryset with a Kusto query to detect the condition. You can then create an alert based on that query, and in this case, you have control over how frequently the query runs. Solved: Re: How to Set Data Activator Trigger to Check Eve... - Microsoft Fabric Community

     

    Hope this helps. Please reach out for further assistance.

    Please consider marking the helpful reply as Accepted Solution to assist others with similar issues.

     

    Thank you.

4 Replies

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support

    Hi saud968 ,
    Thanks for engaging with Fabric Community,

    Just to clarify, Data Activator checks conditions by default every hour and there is no way to change this frequency. So if the condition remains true, it can trigger an alert each hour during those checks.

    References:

    Power Bi visual alert frequency in Activator 
    Activator alert frequency 

     

    The “Time elapsed” setting means: How long Data Activator should wait before treating the condition as no longer true if no new data arrives.

    Time Elapsed 

     

    So in your setup:

    >The condition is being checked every hour. Since data is arriving regularly and the condition stays true, alerts are triggered each hour.

    >If you want to avoid repeated alerts, you might need to add some logic using Power Automate to limit how often alerts are sent.

     

    In a similar discussion, the suggested approach is to use a KQL Queryset with a Kusto query to detect the condition. You can then create an alert based on that query, and in this case, you have control over how frequently the query runs. Solved: Re: How to Set Data Activator Trigger to Check Eve... - Microsoft Fabric Community

     

    Hope this helps. Please reach out for further assistance.

    Please consider marking the helpful reply as Accepted Solution to assist others with similar issues.

     

    Thank you.

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support

    Hi saud968 ,

    Just following up on your issue. If the provided response has resolved your concern, please mark it as the Accepted Solution to help others with similar queries. If you need further assistance, feel free to reach out.

    Thank you!

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support

    Hi saud968 ,

    Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries. 

    Otherwise, feel free to reach out for further assistance.

    Thank you.