Unable to pin merged query results - Azure Workbook

Question

Hi,

I've a requirement to merge the Metric & Azure resource graph query results. I'm able to merge it, but i need to pin the data into Azure dashboard. It looks like the pin options are not available only for the merged table. Is there anyway where we can pin the merged query results into Azure dashboard?

Thanks in advance!

Answer 1

Hello, Welcome to MS Q&A

To pin merged Metric and Azure Resource Graph query results into an Azure dashboard, you can follow these steps:

1. In the Azure portal, open the Azure Monitor Metrics Explorer.
2. Select the Azure Resource Graph query you want to merge with a metric chart.
3. Select the "Pin to dashboard" button and choose "New dashboard."
4. In the "New dashboard" pane, enter a name for the dashboard and select "Create."
5. In the dashboard, select "Add tile" and choose "Chart."
6. In the "Add chart" pane, select the "Azure Monitor" tab and choose the subscription and resource group containing the metric you want to add.
7. Choose the metric you want to add and configure the chart as desired.
8. Select "Apply" to add the chart to the dashboard.
9. In the dashboard, select "Edit" and then select the chart you just added.
10. In the chart settings, select "Add series" and choose "Azure Resource Graph."
11. Select the Azure Resource Graph query you want to merge with the metric chart.
12. Configure the query as desired and select "Apply."
13. In the chart settings, you can customize the chart type, legend, and other options as desired.
14. Select "Apply" to save your changes.
15. Select "Pin to dashboard" to pin the merged chart to the dashboard.

For more detailed instructions, you can refer to the following resources:

• Monitor your Azure services in Grafana
• Analyze metrics with Azure Monitor metrics explorer
• Quickstart: Run Resource Graph query using Azure portal

Can you please check and update

Kindly accept answer if it helps

Thanks

Deepanshu