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

     

     

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

      • vkdubw's avatar
        vkdubw
        Regular Visitor
        9 years ago

        Yes, that's what I'm expecting in the Dashboard view, but there I see nothing.  The screenshot from the "Last 24 hours" is the one from the Dashboard view.  When clicking on the box in the Dashboard view, I see nothing, just the faint outline of the tile. I will say the Dashboard and the Report have two different names.  I've seen in other areas there may be issues if things are named differently, could this be the case here though?

        thanks.