Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Uttasarga
Frequent Visitor

Receiving Emails for all the Data points from Reflex Trigger

Hello Everyone, I started to play around real-time alerting system and came across Data Activator and Reflex Trigger.
In my scenario, I have a Dashboard that shows the name of the views in Cloud data warehouse and load times for each of them every single day, for the past 7 days.
Now, I created a new page, with view names at the left, and status of the load of Views on a given single current day. Now:
1. If a View hasn't loaded past SLA, which means It will load late, I mark it as '0'
2. If a View will load on time, I mark it as '1'
3. If a View is still pending to be loaded and is within SLA, I mark it as '-1'


Now, 

Uttasarga_0-1721435594854.png


Now, within the Data Activator - I have provided the below conditions:

Uttasarga_1-1721435653210.png
Now, I am trying to get email alerts for only the views that I have selected(Which is in the List within the Image Above)

I am detecting changes within the view status, when it changes to Zero, to email me once every two hours.

Uttasarga_2-1721435753604.png

I am getting emails for all the Views, and not all are late!

 

 

5 REPLIES 5
v-tangjie-msft
Community Support
Community Support

Hi @Uttasarga ,

 

You mean you still received the email even though the trigger conditions weren't met, right?

 

Best Regards,

Neeko Tang

Hi Neeko, @v-tangjie-msft 

Okay - since I am trying to get emails for only those views, for which the Status of their load "IS EQUAL TO" ZERO - 0(NOT LOADED), why am I receving emails for all the views which are a part of the Report?

Hi @Uttasarga ,

 

You can create a measure and then set up an alert for that measure.

(1) This is my test data.

vtangjiemsft_0-1721719842487.png

(2)We can create a measure.

Measure = MAX('Table'[status])

(3) Set up an alert for that measure.

vtangjiemsft_1-1721719896495.png

vtangjiemsft_2-1721720023140.png

Here's the overall layout:

vtangjiemsft_3-1721720157216.png

And here is the email I received:

vtangjiemsft_4-1721720260428.png

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Hi @v-tangjie-msft , I think I was able to do the steps which you are showing up above. But, the issue comes when I expcet an email at 7:00 AM EST and I never receive it. That's probably because we need Streaming Data (Timestamp of Every Second) to work with Data Activator.

Hi @Uttasarga ,

 

Do you mean that there is a delay in the alert emails you receive not being sent as expected or that your triggers are not triggered so that you do not receive the alert emails? So with regards to the original question of your post, has the issue been resolved?

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Helpful resources

Announcements
Sept Fabric Carousel

Fabric Monthly Update - September 2024

Check out the September 2024 Fabric update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors