Refresh Date trigger?

[Dellis81]

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!

[parry2k]

@Dellis81 Is this checked?

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Dellis81]

Yes, it is.

Thanks for your quick response 🙂