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

Join 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

Reply
gracielatriv
Frequent Visitor

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!!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @gracielatriv ,

 

The types of conditions are divided into the following categories, which you can choose according to your needs.

vtangjiemsft_0-1723515750926.png

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.

vtangjiemsft_1-1723515871825.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. 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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?

gracielatriv_0-1723457835783.png

is it possible to create custom conditions?

Thank you very much!



Anonymous
Not applicable

Hi @gracielatriv ,

 

The types of conditions are divided into the following categories, which you can choose according to your needs.

vtangjiemsft_0-1723515750926.png

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.

vtangjiemsft_1-1723515871825.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 @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!

Anonymous
Not applicable

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

exceloffthegrid.com

 

Best Regards,

Neeko Tang

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

May FBC25 Carousel

Fabric Monthly Update - May 2025

Check out the May 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Kudoed Authors