Forum Discussion
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)....
lbendlin
Super User
Super User1. 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.