Forum Discussion
How to display DateTime with TimeZone in table
Hello, I use a SQL Server database to store values. My datetime is in UTC. I want to show the date as locale ("Western Europe") and i'm using direct query (import is not an option). I wanted to ...
v-yanjiang-msft
Community Support
Community SupportHi optiwatt ,
I create a DirectQuery sample to test. If you already know the offset is 2 hours, you can directly add a custom column:
[Time]+#duration(0,2,0,0)Get the result:
Then remove the original column, get the correct datetime in Desktop:
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.