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

     

     

ShrikantKhanna's avatar
ShrikantKhanna
Helper II
9 years ago

When you need Last Refreshed at on the report page - You may not need to create a new calculated column. You can create a measure "LAST REFRESHED = NOW()"

You can use a card visual and put this measure in fields.

This should work.

 

 

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.

  • ShrikantKhanna's avatar
    ShrikantKhanna
    Helper II
    9 years ago

    Hi wynhopkins

     

    This may be due to refreshing of report that happens when you open power bi.com. Reports dont have an option to show last refresh time as the way it is possible on any tile on dashboard. It can be helpful if we can also have this on reports as well.

    I prevent myself from refreshing powerbi.com or logging back in so that it remains the same and does not differ, Instead, I remain logged in and use different report for other work. The moment it refreshes it takes the most recent timestamp, however, the dataset was refreshed at a different time or at scheduled timestamp.