Adding Last Refresh Date & Time to a Power BI Report

A great addition to your Power BI reports is to add the "Last Updated Time" for automated reports. This allows your Dashboard or App consumers to quickly see when the report was last updated.

Follow these quick steps to add this:

1. In Power Query, add a new blank query.

2. In the Advanced Editor, add this M code.

let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source

3. Rename the table "Date Refreshed"

4. Save and close your query

5. Add the following measure to your report.

Date Refreshed = CONCATENATE("Data Updated: ", VALUES ('Date Refreshed'[Date Last Refreshed]))

Got any other Power BI tips to help consumers? Or know a better way to do this?

Feel free to share below!