Explore KQL table data with Copilot

With Copilot, you can preview, explore, and visualize data in Kusto Query Language (KQL) tables in the Real-time Hub.

Access Copilot

There are three ways to access the Explore data option for KQL tables in the Real-time Hub.

Explore data-in-motion tile

1. Select the Explore data-in-motion tile.
2. Filter by the tables data type.
3. Select a KQL table, and then select Choose.

List of Recent streaming data

1. In the list of Recent streaming data, filter by the tables data type.
2. From a KQL table's context menu (three dots), select Explore data.

KQL table details

1. Open the KQL table details.
2. Select Explore data from the upper tool bar.

Explore data with Copilot

1. Ask a question or make a request about the data. For example, "Show me the total sales by region" or "What are the top five products by revenue?"

2. Continue exploring and drill through the data by asking follow-up questions or making more requests.

3. The filtered data appears in the Copilot pane. Select the expand icon to see the results reflected in the Visual, Table, and Query tabs.

   • Visual
   • Table
   • Query

   If the tile data was tabular, when you go to the Visual tab, select the format you want to use. For this example, select Pie chart.

   

   The Visual tab shows the pie chart for Texas data only.

   

4. Continue exploring and drilling through the data by asking more questions or modifying the visual manually using the Visual Options pane. For more information on customizing the visual, see Customize Real-Time Dashboard visuals.

5. When you're ready to save your insights to the dashboard, select Save to dashboard. This action saves the current view and query as a new tile on the dashboard.

   Each saved tile stays connected to your live data, so as the data updates, your visual does too.

Related content

• Copilot-assisted real-time data exploration