Last Refresh Timestamp Table in Power Query M

Creates a one-row table capturing the exact date and time the query last refreshed, for display on a report.

Date & TimeBeginnerrefreshtimestamplast updated

Power Query M code

let
    Source = #table({"LastRefreshed"}, {{DateTime.LocalNow()}})
in
    Source

Generate a date table in Power Query M

Notes

DateTime.LocalNow() reflects the machine or service running the refresh - use DateTimeZone.FixedLocalNow() if you need a specific offset.

Requirements

None - this is a standalone query.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Last Refresh Timestamp Table.