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

No Need - the Powerquery Solution I Provided accurately reporst the local time irrespective of the location where the data was refreshed

freder1ck's avatar
freder1ck
Kudo Kingpin
8 years ago

Anonymous:

Your approach is brilliant. It uses the US locale to get the time zone shift.

Anonymous wrote:

Table.TransformColumnTypes(#"Changed Type", {{"LastRefresh", type datetimezone}}, "en-US"),

It worked fine in Power BI desktop, locally, but when I uploaded to the service it didn't work right.

 

I think you're on the right track, but I am not quite there yet.