How do I put the last date and time my data was refreshed, on my report?

[croberts21]

I want to put the date and time this PBIX file was refreshed on my report. I found some local logs on my PC, one is named:

PBIDesktop.9984.2022-03-23T15-08-57-840230.log. But I suspect this filename changes with every refresh I do for every PBIX file. I have about 8 PBIX files right now.

How would I get the most recent file that starts with PBIDesktop*.log?

How would I identify the entry that tells me the refresh time and date? 

Thank you.

[johnt75 · Accepted solution]

You can create a new query in Power Query. If you are pulling data from a database you could use a query like "select current_date()", or you could just create a query using M

let
    Source = DateTime.FixedLocalNow(),
    #"Converted to Table" = #table(1, {{Source}})
in
    #"Converted to Table"

Every time your data is refreshed that table will be updated

[croberts21]

Thank you. I'm not familiar with creating a query. Do you have steps that I can read to create this query? I'm still fairly new to PBI.

Do I go to Transform, New Source, Blank Query?

[johnt75]

Yes, New Source -> Blank Query then open the Advanced Editor and replace everything that's in there with the code above

[croberts21]

It works!

Note to self, use a data source that only takes 1 minute to refresh when testing this.

I also noticed I had to hit ENTER after pasted these lines to create a blank line after the other lines. Then it worked right.