Microsoft Fabric Updates Blog

Set Data Activator alerts on KQL Querysets

Real-Time Intelligence is a powerful service that empowers everyone in your organization to extract insights and visualize their data in motion, using items such as Eventstream, Eventhouse, KQL querysets, and Data Activator.

In May, we released capabilities to help you monitor your real-time data through the Real-Time hub and Real-Time Dashboards. Now, we’re excited to share you can configure Data Activator alerts directly on your KQL queries within KQL querysets. Whether you’re tracking real-time metrics or monitoring important logs, this feature guarantees that you receive notifications as soon as something significant occurs.

Set Alerts Based on KQL Query Results or Specific Conditions

With this new feature, you can set alerts to trigger based on specific results or conditions from a scheduled KQL query.

For example, if your KQL DB tracks application logs, you can configure an alert to notify you if the query, scheduled at a frequency of your choice (e.g., every 5 minutes), returns any logs where the message field contains the string “error”.

This feature also lets you monitor live data trends by setting conditions on visualizations, similar to how you can set alerts on visuals within Real-Time Dashboards. For instance, if you visualize sales data distribution across product categories in a pie chart, you can set an alert to notify you if the share of any category drops below a certain threshold. This helps you quickly identify and address potential issues with that product line.

You can choose whether to receive alerts via email or Teams messages when the condition is met. 

This simple experience unlocks many capabilities for organizations looking to improve their operations with real-time monitoring and alerting

Learn more, and help us with your feedback

To read more about setting alerts for KQL querysets, check out the documentation. To find out more about Real-Time Intelligence, go to https://aka.ms/RealTimeDocs.

We’d love to hear what you think and how you’re using the product. The best way to get in touch with us is through our community forum or submit an idea. For detailed how-tos, tutorials and other resources, check out the documentation.

רשומות קשורות בבלוג

Set Data Activator alerts on KQL Querysets

אוקטובר 31, 2024 לפי Jovan Popovic

Fabric Data Warehouse is a modern data warehouse optimized for analytical data models, primarily focused on the smaller numeric, datetime, and string types that are suitable for analytics. For the textual data, Fabric DW supports the VARCHAR type that can store up to 8KB of text, which is suitable for most of the textual values … Continue reading “Announcing public preview of VARCHAR(MAX) and VARBINARY(MAX) types in Fabric Data Warehouse”

אוקטובר 29, 2024 לפי Dandan Zhang

Managed private endpoints allow Fabric experiences to securely access data sources without exposing them to the public network or requiring complex network configurations. We announced General Availability for Managed Private Endpoint in Fabric in May of this year. Learn more here: Announcing General Availability of Fabric Private Links, Trusted Workspace Access, and Managed Private Endpoints. … Continue reading “APIs for Managed Private Endpoint are now available”