Microsoft-Fabric

The Digital Twin Builder in Microsoft Fabric Real-Time Intelligence is a design surface for representing real-world systems as manageable, structured entities inside Fabric.

A digital twin is essentially a logical model of something in the real world—such as a device, customer, room, vehicle, or any other object that produces events or has measurable state. The new builder allows you to define these entities directly within the Fabric experience without requiring a separate digital twin service.

2026-07-16

Fabric Maps allow you to visualize spatial data as it changes in real time. When integrated with Real-Time Intelligence, you can stream live data directly from Eventstreams or query current states from KQL databases.

Each map layer can represent different metrics — such as sensor status, delivery vehicle locations, or regional anomalies — updated continuously as new events arrive.

You can also apply time slicers and filters to replay historical activity, helping to analyze event sequences over time.

2026-07-14

Dashboards are an effective way to visualize data, but not every use case involves a person watching a screen.

In many organizations, the most valuable insights come when real-time intelligence is embedded directly into operational systems.

Microsoft Fabric makes this possible by allowing you to expose query results as APIs — typically REST endpoints built on top of KQL Databases. This means that the same data you’re using in dashboards can also be made available to web or mobile applications, business workflows, or partner integrations.

2026-07-12

In the past, if you wanted a real-time Power BI dashboard, you had to use streaming datasets — data pushed directly into Power BI from an external source.

While that approach worked, it came with significant limitations: the data couldn’t easily be joined with historical information, retention was limited, and managing the push model was complex.

That model is now deprecated — streaming datasets shouldn’t be used for new solutions.

2026-07-10

Thresholds are great for simple conditions — but they fall short when what’s normal changes throughout the day, week, or season. That’s where anomaly detection comes in.

Instead of relying on fixed limits, anomaly detection uses statistical and machine learning techniques to model what’s normal for a given signal, then flag data points that deviate from that pattern.

For example, network traffic might be high during business hours but low overnight — a single static threshold would either miss issues or trigger constant false alarms. Anomaly detection adjusts dynamically, recognizing these natural variations in the data.

2026-07-08

In real-time analytics, thresholds are the simplest way to detect when something goes outside of normal operating conditions.

A threshold is just a fixed value or condition applied to a metric. For example, you might set a rule to flag when CPU usage stays above 90% for more than five minutes, or when transaction latency exceeds two seconds.

In Fabric Real-Time Intelligence, thresholds are typically implemented within KQL queries or dashboard visuals — for instance, using conditional formatting to highlight values above a certain limit, or defining an analytic rule to monitor a KPI in real time.

2026-07-06

In recent posts, I’ve focused on dashboards and visualizations — but real-time intelligence goes beyond that. The real power comes when your system doesn’t just display insights but can act on them automatically.

Dashboards are great for monitoring, but most people can’t sit and watch a dashboard all day. Instead, we can use alerts and automation to make the data work for us.

There are a few ways to do this in Microsoft Fabric and the broader Power Platform: Power BI Alerts can be set up on tiles or visuals. They monitor thresholds — like sales dropping below a target — and notify users when conditions are met.

2026-07-04

Warehouses in Microsoft Fabric are designed for structured, relational analytics — and they’re a perfect destination for streaming data that fits those patterns.

In many organizations, data warehouses have traditionally been refreshed through nightly or hourly batch loads. That meant Power BI dashboards and reports were always slightly behind — reflecting yesterday’s or last hour’s data.

With Fabric Eventstreams, we can now stream data directly into Warehouse tables, especially into fact tables that support BI models. This means data becomes queryable within seconds of arrival, rather than waiting for the next batch window.

2026-07-02

One of the most powerful features of Microsoft Fabric is the ability to stream data directly into a Lakehouse.

A Lakehouse is a unified storage system that brings together both structured and unstructured data. It can store raw files, like CSV or Parquet, as well as structured tables in Delta format. That means it’s equally comfortable handling real-time events and batch-loaded historical data.

When we connect Eventstreams to a Lakehouse, the incoming data is written directly into Delta tables. This format supports transactional consistency, so you can query the data immediately while new events continue to arrive.

2026-06-30

While Power BI remains a fantastic visualization tool for business reporting, and we’ll talk more about it later, Fabric Real-Time Intelligence also includes its own built-in real-time dashboards — designed specifically for operational monitoring and live analytics.

These dashboards are native to the Real-Time Intelligence workspace. They connect directly to KQL Databases or Eventhouses, and they display query results that automatically refresh — often in near real time, with sub-second latency.

2026-06-28