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
nwrong
Helper I
Helper I

Display UTC datetime in client's local timezone

In my dataset, I've got datetime values stored in UTC. I need to display it in the client's local time. Is there a way to for reports published to the service to display the UTC datetime in my client's local time zone? Clients are spread across multiple timezones.

 

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @nwrong ,

 

unfortunately, this is not possible.

 

But maybe you might consider this idea.

 

Create a table, that contains the user and their offset in accordance with UTC. Then you can use the USERNAME() function to retrieve the current user and use this inside a measure to transform the UTC timestamp into the time of the user.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

3 REPLIES 3
TomMartens
Super User
Super User

Hey @nwrong ,

 

unfortunately, this is not possible.

 

But maybe you might consider this idea.

 

Create a table, that contains the user and their offset in accordance with UTC. Then you can use the USERNAME() function to retrieve the current user and use this inside a measure to transform the UTC timestamp into the time of the user.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Thanks Tom,

 

that is a good alternative. I'll give it a go.

Did it work?

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.