cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
v-tomars
Microsoft
Microsoft

Dynamic Timezones in PowerBI Service

Hi,

I have a datetime column having data in pst timezone, i want to display the data using the relative date slicer and have users in ist and pst timezones. Is there any way to implement dynamic timezone which would convert the datetime column to end user's timezone?

I tried using DateTimeZone.ToLocal in PowerQuery but it didn't work.

Appreciate any help on this, thanks in advance.

1 REPLY 1
GilbertQ
Super User II
Super User II

Hi @v-tomars 

 

All the Power BI Servers are in UTC as per my blog post below

 

Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & T...

 

The only way I could think of getting this to work is to create a new column in Power Query for IST and PST timezones. I would then have a way to switch between the different timezones which the user can then use to show it in their relevant timezone.





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors