Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Krishanu
Helper I
Helper I

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 local time. 
Now, When I publish this in service , this gets converted into UTC+3 (incidentally - my client is also in UTC+3) , this behavior is strange as Power BI service should be in UTC - This I have validated if I create a seprate column using  datetime.localnow()  and in desktop it shows my local time and in service it shows UTC.

Is the behavior of the text column in pbi service a bug or I am missing something here?
Thanks for your help.

1 ACCEPTED SOLUTION

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @Krishanu 

 

If you change it to a Text column, then use it will not change.


Likewise if you are not using the DateTime.LocalNow() it will keep the datetime column in the required format.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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?

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors