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.
Your data is secure. Dashboards and dashboard-related metadata about users is encrypted at rest.
Create a dashboard
In the navigation bar, select Dashboards and select New dashboard.
Select a dashboard name and Create.
Add data source
Add the required data sources for the dashboards.
Select Data sources menu item on the top bar. Select the + New data source button in the Data sources pane.
In the Create new data source pane:
- Enter the Cluster URI or partial name including region and select Connect.
- Select the Database from the drop-down list.
- Use the default or modify the Data source name, if needed.
- Select Apply.
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.
Select Parameters on the top bar. Select the + New parameter button in the Parameters pane.
Enter values for all the mandatory fields and select Done.
|Parameter display name||The name of the parameter shown on the dashboard or the edit card.|
|Parameter type||One of the following:
|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:
|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 uses Kusto query language snippets to retrieve data and render visuals. Each query can support a single visual.
Select Add Query from the dashboard canvas or the top menu bar.
In the Query pane,
- Select the data source from the drop-down
- Type the query, and select Run
- Select + Add visual
In the Visual formatting pane, select Chart type to choose the type of visual.
Name the visual and select Apply changes to pin the visual to the dashboard.
You can resize the visual and Save changes to save the dashboard.
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
Select the Share menu item in the top bar of the dashboard.
Select Manage permissions from the drop-down.
To grant permissions to a user in the Dashboard permissions pane:
- Write the user's name or email in Add new members box.
- Select the Permission level as Can view or Can edit and then click Add.
Change a user permission level
To change a user permission level in the Dashboard permissions pane:
- Use the search box or scroll the user list to find the user.
- Change the Permission level as needed.
Share the dashboard link
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
Select Edit in dashboard menu to switch to edit mode.
Select Auto refresh.
Toggle the option so auto refresh is Enabled.
Select values for Minimum time interval and Default refresh rate.
Select Apply and Save the dashboard.
- 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.