Last Refresh Date per Query Excel

[fdiddy]

Hi All,
Looking for a solution to show Last Query Refresh Date for a specific query.

I have approx 6 Queries - each query i want to show (in that table once loaded) the last refresh date.

the data sources are a mix between SP & SQL

Thanks !

 

[smozgur]

Just an idea without using VBA. If you are willing to use one of the column headers to show the update time, then the following sample code might help.

Sample data - Table Name = "Table1"

1241493.xlsx
	A	B	C
1	field1	field2	field3
2	Sample text 1 here	4	7
3	Sample text 2 here	5	8
4	Sample text 3 here	6	9
Sheet1

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    LastRefresh = Table.RenameColumns(Source, {"field1", "Last Update: " & DateTime.ToText(DateTime.LocalNow(), [Format="dd MMM yyyy H:m"])})
in
    LastRefresh

Last Update: 19 Jul 2023 20:45	field2	field3
Sample text 1 here	4	7
Sample text 2 here	5	8
Sample text 3 here	6	9

In fact, a little bit more creativity, you don't even have to remove the original header, but add the last update time in parentheses maybe?

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    FirstColumnHeader = Table.ColumnNames(Source){0},
    LastRefresh = Table.RenameColumns(Source, {FirstColumnHeader, FirstColumnHeader & DateTime.ToText(DateTime.LocalNow(), [Format=" (dd MMM yyyy H:m)"])})
in
    LastRefresh

field1 (19 Jul 2023 20:48)	field2	field3
Sample text 1 here	4	7
Sample text 2 here	5	8
Sample text 3 here	6	9