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

How to add a refresh date to your report

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.

add a refresh date

Open Power Query and open the query of this table then create a 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.

Custom analyser

Custom analyser

With ‘Custom analyser’ feature, Power BI Sidetools users can use external tools built by the…

Read More

One Comment

Leave a Reply

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