Forum Discussion
Issue with Converted Date changing back to UTC0 when Scheduled Refresh occurs in Power BI Service
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
Hi Anonymous ,
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
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.
1 Reply
Hi Anonymous ,
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
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.