Forum Discussion
mdzej
3 years agoNew Member
Power Query - Incremental refresh - get name of current query
Hi, For the purpose of handling query folding in ODBC incremental refresh with detect changes, I would like to improve query to have different query for the detect changes part (names ***Canary)....
mdzej
2 years agoNew Member
thx, what i thought is to configure the main query to read if its canary or std, and than for canary take only max date, instead of full query. This would make quering the source faster, as there is no query folding -> connecting through google big query odbc driver.
lbendlin
Super User
2 years agoI don't think there is a way to probe which of the queries is running.