Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This article explains how to create Fabric Activator alerts from a KQL Queryset. For more information, see What is Activator. You can use Activator on a KQL Queryset to trigger notifications in two modes:
Send alert notifications either to yourself, or to others in your organization. Notifications can be sent by email or Microsoft Teams message.
Here are some ways you can use Activator alerts with KQL queries:
authorization error
in the table’s message column.Important
Only queries against KQL databases within an Eventhouse are supported. If your KQL queryset is connected to an external Azure Data Explorer cluster, creating an alert is not supported.
The following steps show you how to create an alert on a query that creates a visualization, or on a query that doesn't create a visualization.
Choose the tab that corresponds to your desired workflow.
Important
Timechart visualizations are not supported in this scenario. They are supported in Create Activator alerts from a Real-Time Dashboard.
Open the workspace that contains your KQL Queryset.
Browse to your KQL Queryset and select it to open.
Run a query that returns a visualization.
Once the query returns results, select Set Alert on the top ribbon.
For example, the following query is based on the sample Bicycles data from the Real-Time Intelligence tutorial.
TutorialTable
| where Timestamp < ago(5m)
| summarize NumberOfBikes=sum(No_Bikes) by Neighbourhood
| render columnchart
The query returns a column chart that shows the number of bikes available in each neighborhood. Use this chart to set alert conditions.
Set a time frequency for how often the query is run. The default is five minutes.
In Conditions, specify your alert conditions as follows:
In Action, specify whether you want your alert via email or Microsoft Teams. In the side pane, you can configure notifications that are sent to yourself. To send notifications to a different user, see Optional: Edit your rule in Activator.
In Save location, specify where to save your Activator alert. Choose an existing workspace, and save either in an existing activator or a new one.
Select Create to create your Activator rule.
When your activator is saved, the side pane displays a link to your item. Select the link to further edit in Activator. This step can be useful if you want to do one of the following actions:
For information on how to edit rules in Activator, see Create Activator rules.
In the activator itself, you can also view the history of the query results and the history of the rule activations. For more information, see Create Activator rules.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Certification
Microsoft Certified: Fabric Analytics Engineer Associate - Certifications
As a Fabric analytics engineer associate, you should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions.
Documentation
Create Activator alerts from a Real-Time Dashboard - Microsoft Fabric
Learn how to create an Activator alert from a Real-Time Dashboard and receive real-time notifications when conditions are met.
Latency and accuracy considerations in Activator rules - Microsoft Fabric
An overview of Activator latency considerations and performance when building Activator rules.
Activator capacity consumption, usage reporting, and billing - Microsoft Fabric
Activator is part of Microsoft Fabric Real-Time Intelligence and billing is based on the consumption of various resources. This article reviews the types of consumption activities and impact on billing.