Forum Discussion
Reflex/alert Question
Hello everyone! Nice to meet you once again. I have a specific need that I don't know if it can be solved with Data Activator.
I have a lakehouse where I store my tables already cleaned and transformed. I need to know if I can create alerts when a field in one of the columns of my tables is returned blank by adding a condition on another column.
How could I achieve this?
Thank you very much!!
Hi gracielatriv ,
The types of conditions are divided into the following categories, which you can choose according to your needs.
Detection conditions in Data Activator - Microsoft Fabric | Microsoft Learn
There are no specific requirements for visual objects on the real-time dashboard, but the following requirements need to be met.
Data Activator limitations - Microsoft Fabric | Microsoft Learn
Through my testing, [Value] cannot be null, so you can replace null with space in the table and use it as the value of the condition.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.
5 Replies
Hi gracielatriv ,
Creating alerts directly from tables in Lakehouse is not supported.
You need to create a KQL database, then create a shortcut to that Lakehouse in the KQL database, then create a real-time dashboard with the KQL database you just created selected as the data source for that dashboard, and then create Data Activator alerts from the real-time dashboard.
For more details, please refer:
Create OneLake shortcuts in a KQL database - Microsoft Fabric | Microsoft Learn
Create a Real-Time Dashboard (preview) - Microsoft Fabric | Microsoft Learn
Create Data Activator alerts from a Real-Time Dashboard - Microsoft Fabric | Microsoft Learn
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.
Hello Anonymous ,
Thank you very much for your answer, it has helped me a lot! I have another question, what type of condition should I apply to monitor blank fields in a column from Data Activator? Do I need to apply it to a specific visual object first and then select one of these options?
is it possible to create custom conditions?
Thank you very much!
Hi gracielatriv ,
The types of conditions are divided into the following categories, which you can choose according to your needs.
Detection conditions in Data Activator - Microsoft Fabric | Microsoft Learn
There are no specific requirements for visual objects on the real-time dashboard, but the following requirements need to be met.
Data Activator limitations - Microsoft Fabric | Microsoft Learn
Through my testing, [Value] cannot be null, so you can replace null with space in the table and use it as the value of the condition.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.
