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...