This Power Query allows you to specify the locale that the last refresh date and time should use. This should help with the difference between your local desktop and the server when you refresh manually or by scheduled refresh.

For our example, we used Switch Zone +10 to reflect the Brisbane / Australia Region.

let
Source = #table(type table[LastRefreshUTC=datetime], {{  DateTimeZone.FixedUtcNow() }}),
    #"Added Custom" = Table.AddColumn(Source, "Last Refresh", each DateTimeZone.SwitchZone([LastRefreshUTC],10)),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"LastRefreshUTC"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns",{{"Last Refresh", type datetimezone}}),
    #"Added Refresh Text" = Table.AddColumn(#"Changed Type1", "Last Refresh - Text", each "Last refreshed: " & DateTimeZone.ToText([Last Refresh], "d MMM yyyy h:mm tt"))
in
    #"Added Refresh Text"
  • No labels