Trying to add a date/time card to a report

[Fusilier2]

I'm trying to add a card or similar to my report that will show when a report was last refreshed.

Can anybody point me to some simple instructions?

I tried following this YouTube video from the Guy in a Cube channel:

Date/Time 

However, when I get to the stage where I'm supposed to convert the query into a table (1.12), I'm not given the option to convert to a table:

Don't know if this is beacause PBI has changed since the video was made (2021) and 

I'm using the November 2024 vdesktop version, or because I'm doing something wrong? Although I think I've followed the video step by step.

Can anybody help please?

[Fusilier2]

Thank you very much. Works like a dream!

[Bibiano_Geraldo · Accepted solution]

Hi @Fusilier2 ,

Go to Advanced editor and paste this M code:

let
    Source = DateTime.LocalNow(),
    #"Converted to Table" = #table(1, {{Source}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type datetime}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Last Refreshed Date"}})
in
    #"Renamed Columns"

This will result in this table with a sinlge column: