Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Last Refresh Date shows UTC
11-28-2023
11:37 AM
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.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2023
01:57 PM
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2023
01:57 PM

Helpful resources
Top Solution Authors (Last Month)
User | Count |
---|---|
43 | |
15 | |
13 | |
13 | |
9 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
50 | |
43 | |
24 | |
22 | |
18 |