Power BI Service not displaying local timezone

[Anonymous]

Hi,

I have a problem that I hope someone has resolved.  I have a visual that displays the last refreshed date and time of a dataset.  It displays perfectly fine in Desktop, but once published, the date/time is showing in US timezone.  All desktop, browser and O365 settings are set to English (Australian), and PowerBI language setting is set to default browser.

What am I missing?

Here is the code that I am using

let
Source = #table(type table[LastRefresh=datetime],
{{DateTime.LocalNow()}})
in
Source

Help......

thanks

Cathy

[v-shex-msft]

HI @Anonymous ,

AFAIK, power bi service not support display datetime with local timezone format, it will transform all datetime values as UTC format.

Maybe you can consider to add a calculated column to manually fix timezone offset(+/- timezone offset) to display datetime values as specific timezone.

Regards,

Xiaoxin Sheng