Use dashboards with Grafana with Azure Data Explorer (ADX)

Azure Monitor dashboards with Grafana allow you to use and create Grafana dashboards directly in the Azure portal. This article explains how to create dashboards with data from Azure Data Explorer (ADX).

Prerequisites

Select the Azure Data Explorer data

Use the following process to add Azure Data Explorer data to a new or existing Grafana dashboard.

  1. Either create a new dashboard or add a visualization to an existing dashboard.
  2. Select Azure Data Explorer for the Data source.
  3. Select a cluster from the Cluster dropdown list OR manually enter the URL for the cluster.
  4. Select a Database and Table with the data you want.
  5. Use the query editor to write a KQL (Kusto) query to retrieve the data that should populate the dashboard.

Screenshot of Azure Data Explorer data source.

Import ADX dashboard JSON

If you have existing dashboards in Grafana that use the Azure Data Explorer data source, you can use the following process to import them into Azure Monitor dashboards with Grafana.

  1. Export the JSON for the dashboard from Grafana.
  2. From the dashboards with Grafana screen, select New > Import. The import screen appears.
  3. Select the option to import the JSON file and select the saved JSON.
  4. Select a subscription from the Subscription dropdown list that has the resource provider.
  5. Select Azure Data Explorer for the data source.
  6. Select the cluster to be included in the dashboard.
  7. If you don't see the cluster in the list, select the Override cluster URI toggle, and then select Enter Azure Data Explorer cluster URI manually from the Cluster URI Source dropdown list. Enter the URL of the cluster in the Cluster URI field.
  8. Select Import.

Screenshot of Azure Data Explorer import screen.