Forum Discussion

Dellis81's avatar
Dellis81
Post Prodigy
5 years ago

Refresh Date trigger?

Hello (again πŸ™‚

I have a simple query that should generate date/time @ refresh.   However, the query apparently fails to be triggered upon a normal refresh process.   I can go into the table and/or query and run run thru the process - resulting in the current date.

let
Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}}),
    #"Duplicated Column" = Table.DuplicateColumn(Source, "LastRefresh", "LastRefreshDate"),
    #"Changed Type" = Table.TransformColumnTypes(#"Duplicated Column",{{"LastRefreshDate", type date}})
in
    #"Changed Type"

 I just don't think this query is getting triggered?   I am grabbing the refresh date from another query via this M code. List.Max(#"RefreshStamp"[LastRefreshDate])

 

What forces a trigger to execute the query?

Thank you!

2 Replies