Grafana 6.4.1, MSSQL.
I’m new to Grafana and I’m having problems adding variables to my dashboard (the dropdown filter).
When I use a variable from my smaller table, it works fine. But when I try to add a variable from the table that exceeds a million rows, it shows this error:
Template variables could not be initialized: query row limit exceeded, limit 1000000”
I’ve already tried turning the selection options on and off, but nothing changed. Also, I’m not using Regex. Am I doing something wrong or Grafana doesn’t really support variables with more than 1M rows?