Forum Discussion

nirrobi's avatar
nirrobi
Helper V
10 years ago
Solved

last time refresh

Hi,   Is it possible to add to the report/dashboard the date and time of the last refresh?   Many thanks.   Nir
Need Help
  • idanco's avatar
    idanco
    10 years ago

    Hi nir,

     

    You can add a calculated column (Last Refresh Column) in the model with the formula =NOW()

    And measure Last Refresh Date :=MAX(Table[Last Refresh Column])

     

    Since calculated columns are calculated only on model refresh - it will make sure the calc is right

     

     

wynhopkins's avatar
wynhopkins
Most Valuable Professional
9 years ago

ShrikantKhanna, that's a good suggestion.

 

I'll have to test it out.

 

On first view it works well in Power BI Desktop

 

When I publish the file to Power BI .com  I get a different result, the one on the right is correct, the =NOW() one on the left has changed...

 

ShrikantKhanna's avatar
ShrikantKhanna
Helper II
9 years ago

Hi wynhopkins

 

This may be due to refreshing of report that happens when you open power bi.com. Reports dont have an option to show last refresh time as the way it is possible on any tile on dashboard. It can be helpful if we can also have this on reports as well.

I prevent myself from refreshing powerbi.com or logging back in so that it remains the same and does not differ, Instead, I remain logged in and use different report for other work. The moment it refreshes it takes the most recent timestamp, however, the dataset was refreshed at a different time or at scheduled timestamp.