Power Query - Incremental refresh - get name of current query

[mdzej]

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). 

To do that i want to create a paramter that have different query for default query and the one searching for max modified date within "***Canary" query. Hence i need to figure out if current query contains "Canary" in its name. 

Could you help finding a fucntion to identify what is current query name? 

[mdzej]

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]

I don't think there is a way to probe which of the queries is running.

[lbendlin]

1. The "canary"  query cannot be administered / modified by you. It is entirely controlled by the Power BI Service

2. I hope you are aware that by selecting change detection you are immediately doubling the amount of storage required, and probably the compute load too. Use only if you are absolutely sure that it provides value.