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

     

     

wynhopkins's avatar
wynhopkins
Most Valuable Professional
10 years ago

Not sure when this feature was added but I just spotted it today

 

Click on the ... in your dashboard, clcik on the pencil to edit, select display last refresh

 

 

 

 

 

vkdubw's avatar
vkdubw
Regular Visitor
9 years ago

I am seeing all these people saying to hover over the tile and click the elipse button... but I do not get the edit or pencil icon when clicking the elipse button when in the dashboard or report.  Is there an IE/Edge configuration I need to uncheck in order to get the edit (pencil) button when clicking the elipse button?

Thanks.

  • wynhopkins's avatar
    wynhopkins
    Most Valuable Professional
    9 years ago

    Hi vkdubw,  I'm not aware of any issue.  My dashboards are not affected by Chrome or Edge.

     

    Are you able to post a screenshot?

     

    I'm not sure if the source of the dashboard is an issue.  Are you getitng your dashboard from a Content Pack or just creating it yourself?

    • vkdubw's avatar
      vkdubw
      Regular Visitor
      9 years ago

      Thanks for the quick response.  Hereare the screenshots from theDashboard (Lst 24 hours) and the Report (Export Only).  I originally created the dashboard with PBI Desktop and published.

      • wynhopkins's avatar
        wynhopkins
        Most Valuable Professional
        9 years ago

        No problem vkdubw,   it looks like your screenshots are from the report view  (I can siee the pin to dashboard icon)

         

        The last time refreshed ellipse is only available in the Dashboard view.  So if you use the pin icon to add the visual to a dashboard then you shold see a different set of options on the elipse when in Dashboard View