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
Anonymous/ Xiaoxin Sheng
Is it planned to provide an implementation by Microsoft for
Power BI service to evaluate the browser time zone settings?
Best would be if the new implementation would do something like:
1. Get the current time zone setting of the connected browser
2. Allow (via dedicated datetime methods) filtering and display to use that request specific user time zone
= Users from Australia see the same reports as those from Europa as those from the USA.
But: Those from Australia with the appropriate Australian time zone, those from Europe ...
Example:
The very same record would show 01:40 May 1, 2018 in Australia
But: 17:40 April 30, 2108 in Switzerland
And: 11:40 April 30, 2018 in New York
Regards, David