Forum Discussion
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
- parry2kSuper User
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.β‘
- Dellis81Post Prodigy
Yes, it is.
Thanks for your quick response π