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
10 years ago

nirrobi Is this for troubleshooting purposes? Just to point out, you can see when the dataset that supports the reports/dashboards was last refreshed. Just click the elipses of the dataset that currently has a scheduled refresh set and it will show you when the last refresh was, and when the next one is scheduled.

You could then assume that all reports / dashboard tiles should be updated based on that date/time.

  • nirrobi's avatar
    nirrobi
    Helper V
    10 years ago

    Thanks for the reply.

     

    Its not for troubleshooting but to know we the last refresh was.

    Meantime I have problem with the schedule refresh and want to know the last time the dataset was refresh, is it possible?

    I want to have tile with last time the dataset was refresh.

     

    Regards,

     

    Nir,