Forum Discussion
Query Folding in Big Query
- 2 years ago
Your question reminded me of Erik Svensen's blog post from 2020 where he walked through determining if query folding is happening or not. His motive for the post was
related to Incremental refresh with data from BigQuery. One of the prerequisites for
Incremental Refresh to work is that Power Query can be folded. The post is a quick
read, see if it adds any insights.
Your question reminded me of Erik Svensen's blog post from 2020 where he walked through determining if query folding is happening or not. His motive for the post was
related to Incremental refresh with data from BigQuery. One of the prerequisites for
Incremental Refresh to work is that Power Query can be folded. The post is a quick
read, see if it adds any insights.
Foodd, this is spot on!
Apparently my query was folding intially...even though "Native Query" is always greyed out. I did one transformation that broke the fold. I got rid of it...nice improvement in refresh.
Much thanks!