Forum Discussion

zahirmohideen's avatar
2 years ago
Solved

Last Refresh Date shows UTC

Hi , 

 

I created the calcualted table for "Last Refresh Date" as below. 

 

let
Source = DateTime.FixedLocalNow(),
#"Converted to Table" = #table(1, {{Source}}),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type datetime}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Refresh Date"}})
in
#"Renamed Columns"

 I am in US Eastern TimeZone.

The dataset  was refreshed at 02:23:13 from the service ( aka gateway )  .

 

But , when I view the column in the desktop , it is correct.

But , in the PBI report in the ( cloud) service  , I see the datetime as 07:23 pm .  It is showing the UTC time. 

 

Isn't "FixedLocalNow" supposed to give me the time in the current timezone ?

Please advise.