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

     

     

wynhopkins's avatar
wynhopkins
Most Valuable Professional
9 years ago

ShrikantKhanna, that's a good suggestion.

 

I'll have to test it out.

 

On first view it works well in Power BI Desktop

 

When I publish the file to Power BI .com  I get a different result, the one on the right is correct, the =NOW() one on the left has changed...

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

All good ideas.

 

I have ended up having a table generated in Power Query called "Last Data Refresh" which is

 

DateTimeZone.LocalNow()

 

This seems to give the local time for me of the last time the data was refreshed. One of my refreshes takes quite a while so it may not be the time the data ws actually pulled from the source system but the time the computations get around to updating thsi value as part of the overall set of queries.