Forum Discussion
Reflex/alert Question
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.
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.
Hi Anonymous ,
Thank you very much for your reply, that was all I needed to know. In conclusion, don't we have a tool in Power BI that can monitor the data audit, with the aim of identifying data that may appear blank or meaningless, such as duplicates in a dimension table?
Thank you very much!
Hi gracielatriv ,
Data Activator is a good choice if you want to monitor and set up alerts. If you want to clean incorrect, unexpected data, then Power Query is a good choice.
Working with duplicate values - Power Query | Microsoft Learn
Best Regards,
Neeko Tang