Last refresh date

Add a refresh date to your report

Final users need to know when the report has been refreshed for the last time. Here is my way to do it. I simply add a refresh date in a visual.

Create a table using ‘Home/Enter data’ menu and name it as you want. Add a column named ‘Index’. Add one line of data typing zero in ‘Index’ column.

Open Power Query and open the query of this table then create a calculated column :

ThisStep = Table.AddColumn(PreviousStep, "Last refresh date", each DateTime.LocalNow(), type datetime)

Use this column in a card visual. The date & time will be updated when you refresh your report. It will not be updated when you simply open the report.

Leave a Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.