DateTime displaying in UTC instead of Central Time when data refreshed in Power BI Service

[lcourt]

I have an hours tracking report which includes clock in and clock out dates and times . I've programed the datetimes in Central Time using DateTime.AddZone([Clock In],-2) in Power Query. My report refreshed normally in Desktop, but after I publish to Service and refresh the data, the clock in and out times show in UTC. I need my report to be in Central Time and refreshed regularly. Any suggestions?

[edhans · Accepted solution]

You need to use the DateTimeZone.SwitchZone function DateTimeZone.SwitchZone - PowerQuery M | Microsoft Docs

So DateTimeZone.SwitchZone([Clock In], -6) (If you are referring to Central TZ in the use, but it is -5 right now. See this blog article on handling daylight savings when doing this sort of thing. Add a Refresh Time Stamp To Your Power BI Reports — ehansalytics