Is it possible to automate a Workbook?

DeHaven Graham 101 Reputation points
2022-08-03T18:39:39.727+00:00

I have a workbook created that queries data from Azure Resource Graph but I have no idea how to automate this runbook, anyone knows how to do this?

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,812 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Maxim Sergeev 6,566 Reputation points Microsoft Employee
    2022-08-04T00:01:03.553+00:00

    Currently the scheduling is not available in Azure Workbooks, there is several reasons and most importantly because it uses browser features. If you want to automate\schedule results of your queries, I recommend using the queries in LogicApps with ARG API calls and sending the results to email by email connectors.

    https://learn.microsoft.com/en-us/azure/governance/resource-graph/tutorials/logic-app-calling-arg

    1 person found this answer helpful.
    0 comments
  2. William Li 0 Reputation points
    2023-05-22T23:16:43.5133333+00:00

    I suppose to schedule a workbook generation, maybe an alternative is to deploy it through azure pipelines along with ARM templates(or terraform etc), then set the azure pipelines to run on a monthly basis schedule.

    Although in saying this, also want to understands why the query needs to be run monthly, since the kusto query in graph probably will grab the latest data anyways when you open the workbook.

    0 comments