Azure Workbooks

  • Article

Workbooks provide a flexible canvas for data analysis and the creation of rich visual reports within the Azure portal. They allow you to tap into multiple data sources from across Azure and combine them into unified interactive experiences. Workbooks let you combine multiple kinds of visualizations and analyses, making them great for freeform exploration.

Workbooks combine text, log queries, metrics, and parameters into rich interactive reports.

Workbooks are helpful for scenarios such as:

  • Exploring the usage of your virtual machine when you don't know the metrics of interest in advance. You can discover metrics for CPU utilization, disk space, memory, and network dependencies.
  • Explaining to your team how a recently provisioned VM is performing. You can show metrics for key counters and other log events.
  • Sharing the results of a resizing experiment of your VM with other members of your team. You can explain the goals for the experiment with text. Then you can show each usage metric and the analytics queries used to evaluate the experiment, along with clear call-outs for whether each metric was above or below target.
  • Reporting the impact of an outage on the usage of your VM. You can combine data, text explanation, and a discussion of next steps to prevent outages in the future.

Accessing Azure Workbooks

You can get to Azure workbooks in a few ways:

  • In the Azure portal, select Monitor > Workbooks from the menu bars on the left.

    Screenshot that shows Workbooks in the menu.

  • In a Log Analytics workspaces page, select Workbooks at the top of the page.

    Screenshot of Workbooks on the Log Analytics workspaces page.

When the gallery opens, select a saved workbook or a template. You can also search for a name in the search box.

The gallery lists all the saved workbooks and templates in your current environment. Select Browse across galleries to see the workbooks for all your resources.

Screenshot that shows the Workbooks gallery.

There are four tabs in the gallery to help organize workbook types.

Tab Description
All Shows the top four items for workbooks, public templates, and my templates. Workbooks are sorted by modified date, so you'll see the most recent eight modified workbooks.
Workbooks Shows the list of all the available workbooks that you created or are shared with you.
Public Templates Shows the list of all the available ready to use, get started functional workbook templates published by Microsoft. Grouped by category.
My Templates Shows the list of all the available deployed workbook templates that you created or are shared with you. Grouped by category.

Data sources

Workbooks can query data from multiple Azure sources. You can transform this data to provide insights into the availability, performance, usage, and overall health of the underlying components. For example, you can:

  • Analyze performance logs from virtual machines to identify high CPU or low memory instances and display the results as a grid in an interactive report.
  • Combine data from several different sources within a single report. You can create composite resource views or joins across resources to gain richer data and insights that would otherwise be impossible.

For more information about the supported data sources, see Azure Workbooks data sources.

Visualizations

Workbooks provide a rich set of capabilities for visualizing your data. Each data source and result set support visualizations that are most useful for that data. For more information about the visualizations, see Workbook visualizations.

Screenshot that shows an example of workbook visualizations.

Access control

Users must have the appropriate permissions to view or edit a workbook. Workbook permissions are based on the permissions the user has for the resources included in the workbooks.

Standard Azure roles that provide access to workbooks:

  • Monitoring Reader includes standard /read privileges that would be used by monitoring tools (including workbooks) to read data from resources.
  • Monitoring Contributor includes general /write privileges used by various monitoring tools for saving items (including workbooks/write privilege to save shared workbooks). Workbooks Contributor adds workbooks/write privileges to an object to save shared workbooks.

For custom roles, you must add microsoft.insights/workbooks/write to the user's permissions to edit and save a workbook. For more information, see the Workbook Contributor role.

Next steps

Create an Azure Workbook