BUG: Error in local time display

[Matan]

Hi,

• 2 identical workspaces: PPU and PRO.
• 3 same object in each: DATAFLOW, DATASET and REPORT.
• Both DATAFLOW containing the same QUERY for "Last Refresh" parameter. which is identical.
• REPORT in PRO workspace showing the currect Local time in ISRAEL, while the REPORT in PPU workspace showing the worng time (-3 hours).
• SAME issue in DESKTOP version.

DATAFLOW PPU:

DATAFLOW PRO:

REPORT PPU:

REPORT PRO:

[v-yanjiang-msft]

Hi @Matan ,

By my test, the code you provided also got wrong value. I modify the code like this:

let
    Source = DateTime.AddZone(DateTimeZone.RemoveZone(DateTimeZone.UtcNow()),-8,00),
    #"Converted to Table" = #table(1,{{Source}}),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Last refresh"}}),
    #"Changed column type" = Table.TransformColumnTypes(#"Renamed Columns", {{"Last refresh", type datetime}})
in
    #"Changed column type"

The "-8,00" means my timezone is UTC+8, you can change the value according to your timezone.

Best regards,

Community Support Team_yanjiang