Forum Discussion
nirrobi
10 years agoHelper V
last time refresh
Hi, Is it possible to add to the report/dashboard the date and time of the last refresh? Many thanks. Nir
- 10 years ago
Hi,
Maybe this will solution will help,
http://www.powerpivotpro.com/2010/11/add-a-last-refreshed-date-readout/
I will try tommorow and update :-)
- 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
skiwi
10 years agoNew Member
You can show this on a tile in a dashboard by clicking the ... on the top right hand corner of the tile, then click the edit pencil, then check the "Display last refresh time". The refresh time will now show at the top of the tile
walton9
8 years agoRegular Visitor
And if there is no edit pencil? and no Tile Details? And no "last date refreshed"?