MSSQL : Error 'Data is missing a time field'

  • What Grafana version and what operating system are you using?
    OS is Win 10 Entreprise LTSC
    SQL Server Express is 19.1 (2019

  • What are you trying to achieve?
    Build a Dashboard, add a time series

  • How are you trying to achieve it?
    With the Query builder

  • What happened?
    I always get the error ‘Data is missing a time field’

  • What did you expect to happen?
    See time series

  • Did you follow any online instructions? If so, what is the URL?
    Introduction to time series | Grafana documentation

I create a column in the DB with contains the Unix timestamp value.

How do you tell Grafana that this column is a time field?

please share the mssql query you are using?

You have no time column selected. If you want time series you need a time column

Indeed. The following query works :

1 Like