{"id":103437,"date":"2024-08-08T18:50:45","date_gmt":"2024-08-08T18:50:45","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=103437"},"modified":"2024-09-03T20:04:42","modified_gmt":"2024-09-03T20:04:42","slug":"microsoft-fabric-using-lakehouse-data-in-real-time-dashboards","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/microsoft-fabric-using-lakehouse-data-in-real-time-dashboards\/","title":{"rendered":"Microsoft Fabric: Using Lakehouse data in Real Time Dashboards"},"content":{"rendered":"

Real-Time dashboards are a great feature in Real Time Intelligence experience to monitor our data. However, by default it’s made to work only with Kusto Databases. The options to create a real time dashboard or to define its data source only accept Kusto Databases.<\/p>\n

What if we would like to see in real time the information we have in a lakehouse as well? Let’s discover a solution for this.<\/p>\n

The Magic Solution: Shortcuts<\/h2>\n

We can create shortcuts in a Kusto database pointing to lakehouse tables. This will allow us to query lakehouse tables using KQL from the Kusto databases.<\/p>\n

\"A<\/p>\n

There are some limitations in relation to what we can do with shortcuts in a Kusto Database, but this doesn\u2019t prevent us to build real time dashboards using the shortcuts.<\/p>\n

In fact, if needed, we can build a Kusto database only for this purpose: Create shortcuts to lakehouse to allow including the queries into a real-time dashboard. This is useful in scenarios where we may not be using real-time ingestion to Kusto databases, but we still would like the real-time dashboard to show information as soon its ingested in the lakehouse.<\/p>\n

Pin to Real Time Dashboard<\/h2>\n

After creating the shortcuts, the next steps are as usual for the creation of real-time dashboards. We can execute a KQL query in a query set and use the Pin to Dashboard button.<\/p>\n

Remember: it needs to be in a query set, not directly in the Kusto Database. The option \u201cPin to dashboard\u201d is not available when we use the Kusto Database directly.<\/p>\n

\"A<\/p>\n

We can choose between creating a new dashboard or adding the query to an existing one.<\/p>\n

Creating Alerts from the Real Time Dashboards<\/h2>\n

The last and most powerful step is the creation of alerts with Data Activator. From the Real Time dashboard, we can do this and it’s very interesting how we are extending all these features to lakehouse tables.<\/p>\n

\"A<\/p>\n

References<\/h2>\n