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
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.
vkdubw what type of graphic is that "Last 24 hours" in the dashboard - is it a standard Card?
Wyn,
Nice - I'll second this one.
My experience is that end users only care if the data is current and actionable OR if it is potentially too stale to use. Whether a tile has refreshed or not has no meaningful implication to them - and it does create confustion.
To address this, would it be worth considering this change:1) "Refresh" should mean "source data last refreshed time".
This data already exists in the admin control panel - so it would seem possible to make it an option to show this in the tile refresh pane. If this change could be implemented, it would lead to the second issue...
2) "Source data last refreshed time" should be in the time zone of the viewer or in hours since last source data refresh.
Right now, PowerBI has an issue of reference time - source data refresh can be "last refreshed at server time" or "last refreshed local PBIX time" - depending on how it is pubished. This leads to end user confusion. If end user local time to end user is not obtainable - "source data last refreshed" might be better as a clock of hours lapsed since last successful refresh.Thoughts?
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.
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
ya, that particular one is a text box but it's the same with all the tiles. Number, Filter, Bar Graph. the tiles just highlight, nothing shows up in the upper right of the tile. I was in a meeting and brought this up yesterday and was told this feature was disabled on PowerBI with the latest release. I haven't been able to find any note or paper mentioning that but am going to look for it today.
thanks again.
vkdubw, feature still working for me (in Australia) - I just created a brand new dashboard on a "free" user licence in case it was a pro v free thing, but still works.
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
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.
