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

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

No way that I know of. This would be SUPER helpful. When you share out a dashboard, not everyone will be able to see when it was last refreshed without this. And this will be the first things people ask or want to know about..."How recent is this?"

  • idanco's avatar
    idanco
    Advocate II
    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

     

     

    • AStolk's avatar
      AStolk
      Frequent Visitor
      10 years ago

      Within Power BI Desktop, this works fine! However, after publishing this to PowerBI.com and executing a refresh within the browser, the result of the Last Refresh Date is always displaying an hour too early. It looks like it's refreshing and displaying the last refresh date and time in GMT timezone, but I'm in GMT+1. Is it possible to take into account the timezone?

    • pmendoza's avatar
      pmendoza
      Frequent Visitor
      10 years ago

      This is not possible in either my Desktop or Service . Am I missing something?

      Thanks!

    • ShrikantKhanna's avatar
      ShrikantKhanna
      Helper II
      9 years ago

      When you need Last Refreshed at on the report page - You may not need to create a new calculated column. You can create a measure "LAST REFRESHED = NOW()"

      You can use a card visual and put this measure in fields.

      This should work.

       

       

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

        ShrikantKhanna, that's a good suggestion.

         

        I'll have to test it out.

         

        On first view it works well in Power BI Desktop

         

        When I publish the file to Power BI .com  I get a different result, the one on the right is correct, the =NOW() one on the left has changed...