Visualize data with Azure Data Explorer dashboards(Preview)

Azure Data Explorer is a fast and highly scalable data exploration service for log and telemetry data. Azure Data Explorer provides a web application that enables you to run queries and build dashboards. Dashboards are available in the stand-alone web application, the Web UI. Azure Data Explorer is also integrated with other dashboard services like Power BI and Grafana.

Azure Data Explorer dashboards provide three main advantages:

  • Natively export queries from the Web UI to Azure Data Explorer dashboards.
  • Explore the data in the Web UI.
  • Optimized dashboard rendering performance.

The following image depicts an Azure Data Explorer dashboard.

Final dashboard

Important

Your data is secure. Dashboards and dashboard-related metadata about users is encrypted at rest.

Create a dashboard

  1. In the navigation bar, select Dashboards and select New dashboard.

    New dashboard

  2. Select a dashboard name and Create.

    Create a dashboard

Add data source

Add the required data sources for the dashboards.

  1. Select Data sources menu item on the top bar. Select the + New data source button in the Data sources pane.

    Data source

  2. In the Create new data source pane:

    1. Enter the Cluster URI or partial name including region and select Connect.
    2. Select the Database from the drop-down list.
    3. Use the default or modify the Data source name, if needed.
    4. Select Apply.

    Data source pane

Use Parameters

Parameters enable using dashboard filters. Parameters significantly improve dashboard rendering performance and enable you to use filter values as early as possible in the query. For more information about using parameters, see Use parameters in Azure Data Explorer dashboards.

  1. Select Parameters on the top bar. Select the + New parameter button in the Parameters pane.

    Select new parameter

  2. Enter values for all the mandatory fields and select Done.

    Parameter pane

Field Description
Parameter display name The name of the parameter shown on the dashboard or the edit card.
Parameter type One of the following:
  • Single selection: Only one value can be selected in the filter as input for the parameter.
  • Multiple selection: One or more values can be selected in the filter as input(s) for the parameter.
  • Time range: Allows creating additional parameters to filter the queries and dashboards based on time.Every dashboard has a time range picker by default.
Variable name The name of the parameter to be used in the query.
Data type The data type of the parameter values.
Pin as dashboard filter Pin the parameter-based filter to the dashboard or unpin from the dashboard.
Source The source of the parameter values:
  • Fixed values: Manually introduced static filter values.
  • Query: Dynamically introduced values using a KQL query.
Add a “Select all” value Applicable only to single selection and multiple selection parameter types. Used to retrieve data for all the parameter values.

Add Query

Add Query uses Kusto query language snippets to retrieve data and render visuals. Each query can support a single visual.

  1. Select Add Query from the dashboard canvas or the top menu bar.

    New query

  2. In the Query pane,

    1. Select the data source from the drop-down
    2. Type the query, and select Run
    3. Select + Add visual

    Execute query

  3. In the Visual formatting pane, select Chart type to choose the type of visual.

  4. Name the visual and select Apply changes to pin the visual to the dashboard.

    Add visual to query

  5. You can resize the visual and Save changes to save the dashboard.

    save dashboard

Share dashboards

Use the share menu to grant permissions for an Azure Active Directory (AAD) user or AAD group to access the dashboard, change a user's permission level, and share the dashboard link.

Important

To access the dashboard, a dashboard viewer needs the following:

  • Dashboard link for access
  • Dashboard permissions
  • Access to the underlying database in the Azure Data Explorer cluster
  1. Select the Share menu item in the top bar of the dashboard.

  2. Select Manage permissions from the drop-down.

    Share dashboard drop-down

Grant permissions

To grant permissions to a user in the Dashboard permissions pane:

  1. Write the user's name or email in Add new members box.
  2. Select the Permission level as Can view or Can edit and then click Add.

Manage dashboard permissions

Change a user permission level

To change a user permission level in the Dashboard permissions pane:

  1. Use the search box or scroll the user list to find the user.
  2. Change the Permission level as needed.

To share the dashboard link:

  • Select Share drop-down and then select Copy link Or
  • In the Dashboard permissions window, select Copy link.

Enable auto refresh

  1. Select Edit in dashboard menu to switch to edit mode.

  2. Select Auto refresh.

    Select auto refresh

  3. Toggle the option so auto refresh is Enabled.

  4. Select values for Minimum time interval and Default refresh rate.

    Enable auto refresh

  5. Select Apply and Save the dashboard.

Note

  • Select the smallest minimum time interval to reduce unnecessary load on the cluster.
  • A dashboard viewer:
    • Can change the minimum time intervals for personal use only.
    • Can't select a value which is smaller than the Minimum time interval specified by the editor.

Next Steps