Forum Discussion
last time refresh
- 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
Hi,
I was noticing that you can have the dashboard tiles displaying a recent refresh date even though the data set itself has not been refreshed, so I think it would mislead the user about the data.
You can click on the ... in the top left of your dashboard next to share, and there is an option to refresh the dashboard tiles as well.
Interesting point, never thought to refresh a dashboard tile independenlty of data refresh.
The whole Dashboard and Report refresh options seem misleading. Data Refresh should be all that's required IMHO