Share queries from Azure Data Explorer web UI

This article describes the process of sharing queries from the Azure Data Explorer web UI. By the end of this article, you'll know how to share a query link, share the query results, or even pin it to a dashboard.

To learn how to run queries, see Quickstart: Query data in the Azure Data Explorer web UI.

Prerequisites

• A Microsoft account or a Microsoft Entra user identity. An Azure subscription isn't required.
• An Azure Data Explorer cluster and database. Use the publicly available help cluster or create a cluster and database.

Share options

The following table outlines the many options for how to share a query.

Action	Description
Pin to dashboard	Display the query in an Azure Data Explorer dashboard.
Link to clipboard	Copy a link that can be used to run the query.
Link, query to clipboard	Copy a link that can be used to run the query and the text of the query.
Link, query, results to clipboard	Copy a link that can be used to run the query, the text of the query, and the results of the query.
Download	Download a KQL file of the query.
Open in Excel	Open a live query in an Excel workbook that can be refreshed directly from Excel.
Export to CSV	Download a CSV of the query results.

Pin to dashboard

To pin a query to a dashboard for continuous monitoring, follow these steps:

1. In the query window, select the query that you want to pin.

2. Select Pin to dashboard.

   

3. In the Pin to dashboard pane:

   1. Provide a Tile name.
   2. Select Use existing or Create new.
   3. Provide the Dashboard name.
   4. Select the View dashboard after creation checkbox (if it's a new dashboard).
   5. Select Pin.

Note

Pin to dashboard only pins the selected query. To create the dashboard data source and translate render commands to a visual in the dashboard, the relevant database must be selected in the database list.

Link to clipboard

To copy a link to share with others, follow these steps:

1. In the query window, select the query that you want to share.

2. Under Copy, select Link to clipboard.

   

3. Paste the link into a new browser window to run the query.

Note

The user must have access to the cluster to run the query.

Link, query to clipboard

To copy a link to share with others and the text of the query, follow these steps:

1. In the query window, select the query that you want to share.

2. Under Copy, select Link, query to clipboard.

   

3. Paste to share. The output lists the link followed by the query text.

Link, query, results to clipboard

To copy a link to share with others, the text of the query, and the results of the query, follow these steps:

1. In the query window, select the query that you want to share.

2. Under Copy, select Link, query, results to clipboard.

   

3. Paste to share. The output lists the link, query text, and query results.

Download

To download a KQL file of the query, follow these steps:

1. In the query window, select the query that you want to download.

2. Select Export > Download.

   

Open in Excel

To access live results of your query in an Excel workbook, follow these steps:

1. In the query window, create and select the query that you want to share.

2. Select Export > Open in Excel.

   

3. Open and share the downloaded Excel workbook, which is connected to Azure Data Explorer and can be refreshed. You can refresh your Excel workbook with new data from Azure Data Explorer, and all related Excel artifacts, like charts and pivot tables, will be updated based on the new data.

Note

Depending on your Excel settings, you may need to enable editing and grant permission to access external data connections for the file to update.

Export to CSV

To export the query results to a CSV file, follow these steps:

1. In the query window, select the query that you want to export.

2. Select Export > Export to CSV.

   

Related content

• Azure Data Explorer web UI query overview
• Write Kusto Query Language queries in the web UI
• Visualize data with Azure Data Explorer dashboards