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
dsmitha
Responsive Resident
Responsive Resident

time zone conversion UTC to local time

Hi,

 

Request your guidance regarding subject matter, am using below mentioned custom column formula to convert UTC to local time, will it work in PBI Service

 

dsmitha_0-1651515385095.png

currently am using desktop version

 

regards,

 

dsmitha

1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

This won't work in Power BI service as service is based on UTC and for it, local time zone is UTC. 

The way out is use following type of construct

 

= DateTimeZone.SwitchZone(DateTimeZone.UtcNow(),5,30)

 

Where 530 is user's time zone. But this is helpful only if all users are based in +0530 time zone. Hence, if somebody is based in say +0200 time zone, his time will be off by 0330. 

If users are in multi time zones, it is better to leave it at UTC only which will be common for all.

Having said above, this thread discusses many possible solutions which has worked for some and have not worked for some. Hence worth exploring for you if above solution is not useful to you (as I said it may work and may not work for you but have a shot) - https://community.powerbi.com/t5/Service/Set-local-time-zone-Power-BI-Service/m-p/114120 

View solution in original post

2 REPLIES 2
Vijay_A_Verma
Super User
Super User

This won't work in Power BI service as service is based on UTC and for it, local time zone is UTC. 

The way out is use following type of construct

 

= DateTimeZone.SwitchZone(DateTimeZone.UtcNow(),5,30)

 

Where 530 is user's time zone. But this is helpful only if all users are based in +0530 time zone. Hence, if somebody is based in say +0200 time zone, his time will be off by 0330. 

If users are in multi time zones, it is better to leave it at UTC only which will be common for all.

Having said above, this thread discusses many possible solutions which has worked for some and have not worked for some. Hence worth exploring for you if above solution is not useful to you (as I said it may work and may not work for you but have a shot) - https://community.powerbi.com/t5/Service/Set-local-time-zone-Power-BI-Service/m-p/114120 

Hi Vijay_A_Verma,

Thank you for clarifying the doubt.  As you said it will be better to leave in UTC

 

Also, thank you for sharing the link

 

regards,

dsmitha

 

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
Top Kudoed Authors