How to include the 'Latest Refresh' date and time in a report?

[AliceW]

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

[Stachu]

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"

[AliceW]

Hi Stachu,

How do I create that table? Do I use the 'Enter Data' button? Where do I enter the formula you've provided?

Thanks!!

[AliceW]

I've also tried 'New table' in the Modelling tab, but I get an error

[Stachu · Accepted solution]

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
    Source

replace it with the one I posted before, click Done, then Close & Apply

[AliceW]

I've missed the part about 'Advanced Editor'. It works!!! Thank you so much!

[Stachu]

glad to hear that 🙂