Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Service not displaying local timezone

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

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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