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

     

     

forzajoensy's avatar
forzajoensy
Frequent Visitor
9 years ago

o show last refreshed on a dashboard

 

click on the 3 dots on the top right OPEN MENU

click on the pencil icon TILE DETAILS

then click

 

FUNCTIONALITY

Display last refresh time

 

 

This will be good enough for most people. The problem with the new measure solution is that once you open the desktop app it will  immediately show you that time as the last refresh time, even if you havent actually refreshed it from the actual data source. 
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I don't get an Open Menu.  I only get Export Data or Remove. 

    Also is there anyway to select the font for this?  I have tried formatting the

    category, but that only changes the Last Refresh and not the actual Data and Time.

    • ShrikantKhanna's avatar
      ShrikantKhanna
      Helper II
      8 years ago

      Hi Anonymous

       

      Which solution are you using ?

       

      • ShrikantKhanna's avatar
        ShrikantKhanna
        Helper II
        8 years ago

        Ignore my message.