Forum Discussion
AliceW
Power Participant
Power ParticipantHow to include the 'Latest Refresh' date and time in a report?
Hi folks,
Can anybody advise on this, please?
I've seen a thread using this formula: = DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())
but for the life of me I can't figure out how to use it. How to create this table?
Big thanks,
Alice
In the main PowerBI window, in the Home ribbon:
Get Data => Blank Query
A new window should open (Query Editor), within that window go to the Home ribbon then Advanced Editor
A new window will open with the code like this
let Source = "" in Sourcereplace it with the one I posted before, click Done, then Close & Apply
6 Replies
- Stachu
Community Champion
you can create a new table in M, that when loaded to the model will give you the refresh time, e.g. like this
let Source = #table({"Last refresh"}, {{DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())}}), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Last refresh", type datetime}}) in #"Changed Type"
