Last Refresh Date shows UTC

[zahirmohideen]

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. 

[djurecicK2 · Accepted solution]

Hi @zahirmohideen ,

 The Power BI Service uses UTC. There are some workarounds in this thread:

https://community.fabric.microsoft.com/t5/Service/Incorrect-Time-Zone-setting-at-Power-BI-Service/td....