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

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.

wynhopkins's avatar
wynhopkins
Most Valuable Professional
9 years ago

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

  • Virtual_Ames's avatar
    Virtual_Ames
    Microsoft Employee
    9 years ago

    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?