Recommended way to convert time zones in Power BI / Power Query

This begs the question how do I explicitly tell Power Query to always convert the value to a specific time zone? The caveat here is that it uses the local time from the regional settings of my machine, meaning that if I was to use a machine that had different regional settings, it wouldn’t yield the correct result. Notice one importing aspect about this approach from the formula bar and that is that it uses the DateTimeZone.ToLocal function which only requires a value with the datetimezone data type. (note that I used the option from the Add Column tab) Once in that group, select the option for time and you’ll see from the dropdown a choice for local timeĪnd the result of that operation will yield something like this. The easies way to accomplish this is to actually go into either the Transform tab or the Add Column tab and go into the Date & Time Group. How do I transform these datetimezone values into my local time zone?Įasies way to transform to local time zone in Power BI / Power Query I’m trying to align all of my dates in my model to be under my current timezone in Panama, but Ken sent me these in his own timezone: I have these dates that Ken sent my way specific for a set of orders that came into our system. Datetimezone data type in Power BI / Power Query I’ve been working with Ken Puls for quite a few years now and he’s usually around 2 hours behind me, so the systems that we use are under a specific timezone for some and in a different timezone for others, which we need to “switch” to a unified timezone. Ken is in Canada, Miguel is in Panama – let’s define a set of appointments specific for both time zones. In Power BI you can have date or date+time fields/columns once they’re loaded into your Data Model, but prior to loading them (inside the Power Query Editor) you can actually have them as date timezone, which is a specific data type that only holds date and time information, but also the time zone. (maybe it was a time zone difference situaton? 🙂 ) I feel like I should’ve posted this blog post a long time ago, but it’s better later than never. Will that be your 8am? Or will that be my 8am? What time is it right now for you? We might share the same time zone, but that is usually not the case with worldwide operations.

Time zones converter