Adding a Last Refresh Date Timestamp to PowerBI
Web Visualization

Adding a Last Refresh Date Timestamp to PowerBI

The value of data can depreciate over time, so having a Last Refresh date on your dashboard helps better conceptualize what they’re seeing. To add this to your PowerBI dashboard, access the Query Editor and add a blank query with the Power Query M language below:

    Source = DateTime.LocalNow(),
    #"Converted to Table" = #table(1, {{Source}}),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "RefreshDate"}}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Renamed Columns", "RefreshDate", "RefreshDate - Copy"),
    #"Renamed Columns1" = Table.RenameColumns(#"Duplicated Column",{{"RefreshDate - Copy", "RDate"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns1",{{"RDate", type date}}),
    #"Duplicated Column1" = Table.DuplicateColumn(#"Changed Type", "RefreshDate", "RefreshDate - Copy"),
    #"Renamed Columns2" = Table.RenameColumns(#"Duplicated Column1",{{"RefreshDate - Copy", "RTime"}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns2",{{"RTime", type time}, {"RefreshDate", type datetimezone}})
    #"Changed Type1"
  1. In the report, add a card visual at the bottom or top corner of the report page. Drop the field from the query you just created in the Fields panel. This will display as the date and time that the data for the report was last updated. 
  2. Format the card visual to be consistent with the rest of your report. 
  3. Refresh your dashboard to ensure that the date and time update accordingly.

Leave a Reply

Your email address will not be published. Required fields are marked *