Display the last refreshed date on the report page

[UdhayakumarT]

Hi everyone,
I’m working on a Power BI dashboard and would like to display the last refreshed date on the report page. Is there a way to do this dynamically so it updates every time the dataset is refreshed?

Thanks in advance!

[Abhilash_P · Accepted solution]

Hi @UdhayakumarT ,

you can display the last refreshed date in your report using Power BI’s built-in functionality. Here's how:

1. Go to the Modeling tab in Power BI Desktop.

2. Click on New Measure and enter the following DAX formula:
   Last Refreshed = "Last Refreshed on: " & FORMAT(NOW(), "dd-mmm-yyyy hh:mm:ss")
   OR

you can create a new table in power query using below 

let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}}),
#"Renamed Columns" = Table.RenameColumns(Source,{{"Date Last Refreshed", "Dashboard Refreshed Date"}})
in
#"Renamed Columns"

[Ritaf1983]

Hi @UdhayakumarT 
Yes please refer :
https://www.youtube.com/watch?v=oN6mOmEruOQ

3 minutes of work 🙂

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[burakkaragoz]

Hi @UdhayakumarT ,

Yep, there’s a pretty easy way to show the last refreshed date on your Power BI report page. You can create a new measure using DAX like this:

Last Refreshed = NOW()

Then, just drop that measure onto your report as a card visual (or whatever fits your style). It’ll update each time the dataset is refreshed, so users always see the current refresh timestamp.

If you want the exact refresh time (not just current time), you can use:

Last Refreshed = UTCNOW()

Just a tip, sometimes visuals might cache the time until the next dataset refresh, so you’ll see the right value after each scheduled or manual refresh.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI