Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
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!!
Solved! Go to Solution.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.