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

     

     

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...

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        All good ideas.

         

        I have ended up having a table generated in Power Query called "Last Data Refresh" which is

         

        DateTimeZone.LocalNow()

         

        This seems to give the local time for me of the last time the data was refreshed. One of my refreshes takes quite a while so it may not be the time the data ws actually pulled from the source system but the time the computations get around to updating thsi value as part of the overall set of queries.