64.1 - Time to update a query, pure M
I tried repeating video 64, this time using only M/Power Query to time how long it takes to update a query.
After many tries, I eventually gave up.
I tried physically printing a time stamp inside a row, that didn't work.
Table.Buffer showed some promise, but that's expensive
I tried DateTime.FixedLocalNow() but I don't trust it.
Ben Gribaudo, how tables think (tables are references, those references are immutable but the actual tables can change9
https://bengribaudo.com/blog/2019/12/...
Chris Webb, timing queries part 1
https://blog.crossjoin.co.uk/2014/11/...
Chris Webb, timing queries part 2
https://blog.crossjoin.co.uk/2016/04/...
00:25 Adding a time-stamp as a row in a table
02:30 Maybe Table.Buffer works?
02:50 Adding the time difference as meta-data
03:36 FixedLocalNow()
05:38 Do you actually need to time a query?
Watch video 64.1 - Time to update a query, pure M online without registration, duration hours minute second in high quality. This video was added by user WesleySon 19 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 43 once and liked it 1 people.