Forum Discussion

Krishanu's avatar
Krishanu
Helper I
5 years ago
Solved

Datetimezone conversion behaves inconsistently

Hi, I have text column in this format  - 2021-07-20T19:01:10.8986983Z As you can see this is in UTC .  In Power BI desktop when I mark the datatype of this column as datetime, its converted into my...
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    Hi Krishanu 

     

    If your data is stored as text it will not change and keep what the value is stored as.


    If you use datetime.localnow/datetimezone.localnow it will always use UTC because this is the time of all the Power BI Servers.

Krishanu's avatar
Krishanu
Helper I
5 years ago

Thanks GilbertQ   for the response.
1. But I didn't understand where from it's getting UTC+3 in pbi service?

2. Is this a bug or this is by design - can I depend on this feature to get the datetime in client's timezone?
3. If this is expected behavior , why datetime.localnow/datetimezone.localnow gives result in UTC?


If you can reproduce this at your side - what could be the possible explanation?

GilbertQ's avatar
GilbertQ
Super User
5 years ago

Hi Krishanu 

 

If your data is stored as text it will not change and keep what the value is stored as.


If you use datetime.localnow/datetimezone.localnow it will always use UTC because this is the time of all the Power BI Servers.