Template Variable based on Log Analytics Workspace does not show items

Lars Gausling 20 Reputation points
2023-06-01T09:06:09.43+00:00

Hello all,

we are planning to use Grafana as a central data visualization and monitoring tool.

Because of this PoC's are created to evaluate Pro's and Con's.

At the moment we are struggeling regarding (at least for me) easy requirement: "Show distinct values from a KQL Query as panel on the Dashboard".

Example: Give me all distinct Azure Data Factory Pipelines based on our Log Analytics Workspace:

ADFPipelineRun
| distinct PipelineName

My expectation is/was that the Variable is showing me all the PipelineNames which I then can use for filter my other Queries . Unfortunately it is only showing "None". When I set up this query as a panel on the dashboard it is working like expected.

Do we do something wrong using template variables ?

Thank you and best regards

Lars

Azure Managed Grafana
Azure Managed Grafana
An Azure service used to deploy Grafana dashboards for analytics and monitoring solutions.
90 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Kayode Prince 0 Reputation points Microsoft Employee
    2023-06-12T19:29:55.02+00:00

    If this is the Azure Monitor plugin, please ensure that your variable query also includes a time range to and the same LA workspace to limit query the scope. You can use time macros to ensure that the variable time range.

    0 comments No comments