topic Re: Adjusting Data Activator Trigger Frequency in Activator

Adjusting Data Activator Trigger Frequency

reniyama — Thu, 28 Nov 2024 16:54:08 GMT

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!

Re: Adjusting Data Activator Trigger Frequency

lbendlin — Thu, 28 Nov 2024 19:27:05 GMT

Have you considered using Power Automate instead?

Re: Adjusting Data Activator Trigger Frequency

reniyama — Thu, 28 Nov 2024 19:36:04 GMT

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

Re: Adjusting Data Activator Trigger Frequency

lbendlin — Thu, 28 Nov 2024 20:43:10 GMT

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.

Re: Adjusting Data Activator Trigger Frequency

jameshutton — Wed, 04 Dec 2024 18:14:00 GMT

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)

Re: Adjusting Data Activator Trigger Frequency

reniyama — Thu, 05 Dec 2024 15:35:49 GMT

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