MSSql Query SQL-Error

Grafana MSSQL
1

Hi all,
I have recently setup a grafana-docker and it seems to work out of the box.

I added a MSSQL data source and tested the connection successfully. However when I try to get data out of the database, the query inspector reports an sql: expected 2 arguments, got 0 error.

My query:

SELECT
  $__time(WSDateTime),
  temp_batt_room as value
FROM
  RFB.dbo.Wv$LiveData$ESS_1_min
WHERE
  $__timeFilter(WSDateTime)
ORDER BY
  WsDateTime ASC

Result :

grafana_error
grafana_error2547×1213 143 KB

However, when I connect with HeidySQL and do a direct query using the executedQueryString from the query inspecor, it seems to work properly

query
query2093×997 220 KB

I am not familiar with grafana or MSSQL. I hope that somebody can point me in the right direction, where the error might result from.

Thank you in advance,
Cheers
Dennis

2

I solved the issue by simply putting the db-name in " ": "RFB"."dbo"."Wv$LiveData$ESS_1_min". So I guess the $ symbol was the problem.

3

This topic was automatically closed after 365 days. New replies are no longer allowed.