Central NJ Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Putting the date a report was last refreshed into your visuals

  • 1.  Putting the date a report was last refreshed into your visuals

    Posted Jul 26, 2018 01:15 PM

    I found another handy little code to show when the data was last refreshed and you can make a visual that shows this date in a report (you don't have to put it in a dashboard).

    Open PowerBI Desktop

    Get Data –-> Blank Query

    Go to Home –> Advanced Editor and replace the code in the window with this:

    let
    Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
    in
    Source

    Click Done and rename the query "LastRefresh_Local" or "Date last refreshed"

    Click Close & Apply

    This code makes a nice little table that returns the current date and time each time we refresh the solution.

    I found this code from this webpage: https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/

    I was able to put a card on my page that shows the Date last refreshed.



    ------------------------------
    Amanda Thompson
    Quality Manager
    Mt. Arlington NJ
    ------------------------------