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.

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.

Manage your external tools easily with Power BI Sidetools

Since the Power BI team allowed to launch external tools from the Power BI desktop ribbon, several tools became available. Do you know you can…

Easily export to Excel with Power BI Sidetools

While working in Power BI desktop, we often need to export to Excel some data sharing with customers or colleagues. Once shared, we don’t want…

Powerful text and file search in Visual Studio Code

Text and file search in Visual Studio Code is really powerful. There are different ways to search and replace. The only difficulty you will meet…

Compare DAX and M formulas in Visual Studio Code

Compare DAX and M formulas in Visual Studio Code is really easy with the help of Power BI Sidetools.As it is possible to transfer DAX…

Translations life cycle management

Translations life cycle management must be considered seriously as soon as we decide to translate Power BI reports. Translating a report in several languages takes…

Automatic translation of visuals labels

Automatic translation of visuals labels in Power BI reports is possible using conditional formating, Tabular Editor and an Excel template. At the moment, labels are…