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

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Coming to this topic late. But I should note that the time refresh it will say in the dashboard is not the time the data set was last refreshed, just the time the dashboard tile was refreshed which will mislead any user.

wynhopkins's avatar
wynhopkins
Most Valuable Professional
9 years ago

HI Anonymous,

 

I just refreshed my data set and the dashboard date refreshed has updated as expected.  So I don't seem to have an issue there.

 

How do you refresh just a dashboard tile?

 

Thanks

 

Wyn