Time Series with MSSQL

I am tiring to make a simple line graph with some data from MSSQL and I have no idea what I am doing wrong.

My SQL is;
SELECT DATEDIFF(s,‘1970-01-01 00:00:00’,Date) as time, BudgetDaily

If I run that query on the DB I get the following back;

Looks good… But when I run that same query in Grafana I get no data back if the query if the format is time series. However, table series will return data.

Must be something I am not understanding here. Can anyone help me out?


Sorry, disregard. Looks like the values need to be stored as numeric types in the DB. I had them as varchars…