M: Create Last Refreshed Table

Power Query: New Source, Blank Query, Advanced Editor

Copy the following code into the Advanced Editor:

let

    Source = DateTime.LocalNow(),

    #"Converted to Table" = #table(1, {{Source}}),

    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "DateTime"}}),

    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"DateTime", type datetime}})

in

    #"Changed Type"