Time of the last refresh

Two techniques for obtaining the PBI dataset’s last refresh time

Importance of the last refresh time

World Time API

let
Source = Json.Document(
Web.Contents(
"http://worldtimeapi.org/api/timezone/",
[
RelativePath =
"/Europe"&
"/Zurich"
]
)
),
datetime = Source[datetime],
#"Converted to Table" = #table({"Last Refreshed Time"}, {{datetime}}),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Last Refreshed Time", type datetimezone}})
in
#"Changed Type"

M Query

let
Source = #table({"Last Refresh"}, {{DateTimeZone.UtcNow()}})
in
Source

Consultant, Business Intelligence, data, and analytics.