Hi Olivier, thanks for your comment. I would find the exact query that Grafana sends to MSSQL. You can either do it in Grafana using the "Query Inspector", or get the query history from MSSQL server. This might be an issue with Grafana templating.

Bill Liu DECLARE @TSQL varchar(8000), @DATE_FROM char(19), @DATE_TO char(19)

SELECT @DATE_FROM = REPLACE('2022-04-28T01:07:35Z', 'T', ' ') SELECT @DATE_TO = REPLACE('2022-04-30T01:07:35Z', 'T', ' ') SELECT @TSQL = ' SELECT DateTime AS time, K12-1STAT.CPV,K12-2STAT.CPV,K12-3STAT.CPV,K12-4STAT.CPV,K12-5STAT.CPV,K12-6STAT.CPV FROM OPENQUERY( INSQL, '' SELECT DateTime, K12-1STAT.CPV,K12-2STAT.CPV,K12-3STAT.CPV,K12-4STAT.CPV,K12-5STAT.CPV,K12-6STAT.CPV FROM Runtime.dbo.WideHistory WHERE wwResolution = 120000 AND wwRetrievalMode = "Average" AND DateTime >= ''''' + @DATE_FROM + ''''' AND DateTime <= ''''' + @DATE_TO + ''''' AND wwTimeZone = ''''UTC'''' ORDER BY DateTime ASC '') ' EXEC (@TSQL)

error: " db query error: mssql: Incorrect syntax near '.'. "

I dont see the '.'. anywhere