Azure Monitoring with Grafana using Log Analytics / Application Insights

  • What Grafana version and what operating system are you using?
    Version 9

  • What are you trying to achieve?
    Creating Dashboards for Azure Monitoring using Azure Log Analytics and Application Insights for API Managements services.

  • How are you trying to achieve it?
    Using Data Source Azure Log Analytics and Application Insights for API Managements services.

  • What happened?
    I am able to plot Render Timecharts using KQL in Log Analytics / Application Insights. But same is not plotting in Grafana using time series.

  • What did you expect to happen?
    Grafana using time series should be plotting graphs as Azure.

  • Can you copy/paste the configuration(s) that you are having problems with?
    // Count of failed and successful requests over time
    requests
    | extend success=tobool(success)
    | where timestamp > datetime(“2022-07-14T17:38:00.000Z”) and timestamp < datetime(“2022-07-14T18:38:00.000Z”)
    | where cloud_RoleName == ‘apim’
    | where client_Type == “PC”
    | summarize
    succeeded=sumif(itemCount, success == true),
    failed=sumif(itemCount, success == false)
    by bin(timestamp, 1m)

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    NO

  • Did you follow any online instructions? If so, what is the URL?
    Nothing so far