Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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,
Now, within the Data Activator - I have provided the below conditions:
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.
I am getting emails for all the Views, and not all are late!
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.
(2)We can create a measure.
Measure = MAX('Table'[status])
(3) Set up an alert for that measure.
Here's the overall layout:
And here is the email I received:
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.
Check out the September 2024 Fabric update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.