Issue with Converted Date changing back to UTC0 when Scheduled Refresh occurs in Power BI Service

[Shnack]

In Power BI Desktop I've converted date/time values in Power Query from UTC to my local timezone. Once published the dates are still in the local timezone, but after the scheduled refresh the converted dates are reset to the original date/time (in UTC).

I understand that we can create a custom column in Query Editor and use DateTime.LocalNow() and #duration() function. However, this solution will not allow report users in different timezones to view the report in the respective local timezone. 

Does anyone know how to prevent the reset to UTC? Or any other work arounds?

Thanks,

Lachie

[Anonymous · Accepted solution]

Hi @Shnack ,

1.Use DAX to create a calculated column that calculate and display the date/time values based on a timezone offset.

LocalTime = [UTCColumn] + TIME(hourOffset, minuteOffset, 0)

2.If you have users with different timezones, you can add their timezone into the user table. 

For more details, please refer:  Showing Current Time and Latest Refresh Time at Local Timezones in the Power BI Report - RADACAD

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

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.