ToLocal() converts to the local time of the Power BI servers, which are set for Universal Coordinated Time. However, as soon as the model is published to the Power BI Service and the data refreshes, the date times are no longer Pacific Time. This expression works great as long as users are in Power BI Desktop in Pacific Time. These clock changes are also known as “Spring forward” and “Fall back.”Ī simple PowerQuery expression can transform Coordinated Universal Time to any local time: DateTimeZone. Under DST, clocks are adjusted ahead one hour in the spring and one hour back in the fall. This would be an easy modification except for the time change that takes place twice a year in most of the US and various parts of the world, called Daylight Savings Time (DST). The accountants are in US Pacific Time (PT), and all events are held in Pacific Time, so it makes sense to convert UTC to PT. The client’s accounting team needs to report on and analyze ticket purchases. Also, the date and time that purchases are made for each event are recorded in UTC. The date and time of each event are recorded in UTC. Customers purchase tickets online or from agents at the event sites. We built an online event management and ticketing system for one of our clients. I also provide my solution for converting UTC to the Pacific Time Zone. Below I explain the problem with Power Query’s ToLocal() function in the Power BI Service in more detail.

However, one has to be careful how and where they are used. However, Power Query lacks a good way to convert a Coordinated Universal Time (UTC) to a local time of your choosing while preserving Daylight Savings Time (DST). Time zone functions do exist. Additionally, the Power BI component Power Query provides a powerful and dynamic tool for loading and transforming data into Power BI’s data model. Power BI provides exceptional business analytic services. Update: Recent updates to the Power BI service need to be reviewed and appropriate updates to the post will be made.

Utc to pst converter online