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

     

     

Rajkumar's avatar
Rajkumar
Advocate II
9 years ago

Hi All,

 

Add a column to your dataset with the below formula.

 

Last Refresh Date Time =DateTimeZone.LocalNow()

 

This will get refresh only,when you click the refresh button. It is working 100% correct. I'm using in my current project PBI Reports.