Forum Discussion
last time refresh
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 :-)
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
Thanks for the quick response. Hereare the screenshots from theDashboard (Lst 24 hours) and the Report (Export Only). I originally created the dashboard with PBI Desktop and published.
No problem vkdubw, it looks like your screenshots are from the report view (I can siee the pin to dashboard icon)
The last time refreshed ellipse is only available in the Dashboard view. So if you use the pin icon to add the visual to a dashboard then you shold see a different set of options on the elipse when in Dashboard View
Yes, that's what I'm expecting in the Dashboard view, but there I see nothing. The screenshot from the "Last 24 hours" is the one from the Dashboard view. When clicking on the box in the Dashboard view, I see nothing, just the faint outline of the tile. I will say the Dashboard and the Report have two different names. I've seen in other areas there may be issues if things are named differently, could this be the case here though?
thanks.
Yep, that's exactly where I'm at. I'm going to give it a few days of rest then pick it up again. Thanks for the confirmation that I'm looking in the correct area.