Adjusting Data Activator Trigger Frequency

[reniyama]

Dear all,

I’m setting up a Data Activator within my organization to send weekly Teams messages when a specific measure in Power BI is above zero.

Currently, my report refreshes weekly, but the Data Activator is being queried hourly, as shown in the screenshot below. This results in hourly Teams messages, which is excessive for the purpose of this development.

Could you please advise on how to adjust the query frequency so that the trigger becomes active only once per week, aligning with the report’s refresh schedule? Or at least someone could please advise in how I could make the message (via Teams) arrive to the User in a Weekly basis? Thank you!

Thank you for your assistance!

[jameshutton · Accepted solution]

Hi @reniyama 

I'm afraid that it's not currently possible to set up a trigger that will warn you every week if the value is greater than zero (although we do have a roadmap item to enable this). However, there is something you can do that might still be useful. If you change your trigger condition to "becomes greater than zero", then it will warn you at most once per week. The difference is that it will only warn you if the value was zero the week before. For example:

Week 1: value = 0 (no alert)

Week 2: value = 1 (you get an alert, because last week it was 0)

Week 3: value = 1 (no alert)

Week 4: value = 0 (no alert)

Week 5: value = 5 (you get an alert, because last week it was 0)

[reniyama]

@jameshutton thank you, I'm looking forward for this implementation, your solution seems a viable option for now 🙂 ... I'm going to try to customize something by using power automate as well, thank you

[lbendlin]

Have you considered using Power Automate instead?

[reniyama]

Hi @lbendlin unfortunately this power automate connector is currently blocked from the admin portal in my organization...

I've opened a ticket to unlock it so I can customize the message even further in Teams.... But still, how could I set up weekly Teams message through this? As the trigger would be also set hourly

[lbendlin]

Data Activator (RTI) is designed to handle event signals - as they happen.  For recurring schedules you will want to use tools that are designed to be able to implement schedules like yours.