Power Query evaluates an M query to determine the data and transformations required for its result. During evaluation, query folding attempts to translate supported transformations into operations ...
This article provides some example scenarios for each of the three possible outcomes for query folding. It also includes some suggestions on how to get the most out of the query folding mechanism, and ...