can I know at what time the data has been refreshed?

[Hector78]

I would like to know the time at the data has been refreshed.

Is it possible?

thank you in advance.

[comish4lif]

Do you have a date time stamp in any of the tables?

I have a card in one of my visuals showing the MAX of Job Completion Time from one of my tables.

Or, are you asking to know when the user hit the "refresh" command in Power BI?

[Hector78]

No I have not.

I am loading an excel file

[rossnruthie · Accepted solution]

Hi @Hector78,

I have added a refresh time to my reports.  There are probably other ways to do it but here is mine.  It is a simple two step process.

First I create a custom column in my calendar query using the following code:

=DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())

Now, whenever you refresh that query you will get a column with the current time.  Then, in my report I create a DAX calculated measure that uses this column.

Last Refresh Date = "Last Refreshed On: " & FIRSTDATE('Calendar'[RefreshDate]) & " (EST)"

And in the report it looks like this: