Forum Discussion
Convert UTC to local client timezone?
HI OneWithQuestion,
As you said, UTCNOW and UTCTODAY will return UTC datetime. If you want to get local datetime, why don't you use NOW and TODAY function to get local datetime?
Notice: NOW, TODAY functions still not works on power bi service.
Time in PBI Service is inconsistent with the local time (non-UTC time) displayed in PBI Desktop
Regards,
Xiaoxin Sheng
That is why (as you mentioned) the NOW does not work in the service.
What I need is to display data to the end users that was stored as UTC but needs to convert to their local timezone.
*Timesheet data or error log events, etc... stored UTC but need to go to local timezone of user viewing service.
How many users are you dealing with? If it's not huge, you could consider building a simple table of users and their default time zones, then using the username function, pull through who's using the report and have it look up and adjust your time fields accordingly?
