Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.