Hello,
I am trying to create a dashboard that shows some status information from sites around the world.
The data comes from an MS SQL Server.
Grafana 11 on Windows Server 2022.
The source table has two columns with datatype DATETIME.
Each row shows the status of a location around the world and those datetime columns show the local datetime (in the timezone of the location).
The issue I am having is that Grafana now converts the values of those two datetime columns to the Dashboard Timezone and this results that all values show the same datetime. But I need to show the local datetime.
I know that Grafana expects all datetime values for timeseries visualization in UTC, this makes complete sense for timeseries data, but can this be disabled somehow?
In the screenshots you see that the raw data has all datetime values in local timezone, that’s what I want to show.
Grafana converts all datetime values to the dashboard timezone and therefore only shows ‘10.01.2025 08:40:00’ for all rows…
The only workaround I found so far is to convert the datetime values to strings in the query.
Raw Data from Database from QUERY:
How Grafana shows it in a Table Panel:
