Forum Discussion
Using Fabric Activator for Alerts on Lakehouse Table Changes (Batch Data)
Hi Fabric Community,
I'm working on Fabric futures on the best approach within Microsoft Fabric.
My Goal:
I need to send an immediate email alert whenever there is a change (increase or decrease) in the data within my Sales Table, which is stored in a Lakehouse.
The Challenge:
- I understand that the Fabric Activator cannot be used directly on a table inside the Lakehouse.
- My data is updated via batch processing (it is not a real-time data stream), which seems to complicate using event-driven tools.
My Attempts So Far: I experimented with setting up the Activator on a related Power BI report, hoping to monitor changes there. However, I haven't found a clean, reliable pattern to make this work for non-streaming, batch-loaded data.
My Question to the Community:
What is the recommended design pattern in Fabric to achieve this?
How can I effectively monitor a batch-updated Lakehouse table for a data condition (e.g., Sales Amount > previous run's Sales Amount) and then trigger an email notification using the Activator
Any insight or examples on triggering alerts based on the result of a batch update would be greatly appreciated!
Thank you, Vamshikrishna
Hi Yadnapathi
Fabric Activator can’t directly monitor Lakehouse tables. It only works with event-based sources such as:
-
Eventstreams
-
Real-Time Hubs
-
Power BI visuals
-
KQL Querysets
If your data is batch-loaded, here’s the simple way to set it up:
-
Create a KQL Queryset on your Lakehouse table to compare the latest batch with the previous one (for example, total sales difference).
-
Schedule this queryset to run automatically after every batch load.
-
Connect it to Fabric Activator and set a detection rule like Delta > 0 or Delta < 0.
-
Add an action to send an email alert, Teams message, or trigger a Fabric pipeline or Power Automate flow.
This is the only supported way right now to trigger alerts for batch changes in Lakehouse data , through a scheduled KQL Queryset feeding Fabric Activator.
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/data-activator/activator-introduction
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/data-activator/activator-alert-queryset?tabs=visualization-
4 Replies
rohit1991Super User
Hi Yadnapathi
Fabric Activator can’t directly monitor Lakehouse tables. It only works with event-based sources such as:
-
Eventstreams
-
Real-Time Hubs
-
Power BI visuals
-
KQL Querysets
If your data is batch-loaded, here’s the simple way to set it up:
-
Create a KQL Queryset on your Lakehouse table to compare the latest batch with the previous one (for example, total sales difference).
-
Schedule this queryset to run automatically after every batch load.
-
Connect it to Fabric Activator and set a detection rule like Delta > 0 or Delta < 0.
-
Add an action to send an email alert, Teams message, or trigger a Fabric pipeline or Power Automate flow.
This is the only supported way right now to trigger alerts for batch changes in Lakehouse data , through a scheduled KQL Queryset feeding Fabric Activator.
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/data-activator/activator-introduction
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/data-activator/activator-alert-queryset?tabs=visualization-
Hi rohit1991 ,
Thanks for you're response.
I already tried with a Power BI report. Let me try with KQL Queryset.
Hi Yadnapathi
As you mentioned, could you let us know whether you tried the KQL Queryset? If you have any additional questions, please feel free to reach out.
Hi Yadnapathi
Thank you for reaching out to the Microsoft Fabric Forum Community.
rohit1991 Thanks for the inputs.
I hope the information provided by user was helpful. as you said please try from your end & If you still have questions, please don't hesitate to reach out to the community.
