Forum Discussion
Query Folding in Big Query
Does anyone have a solution to enable query folding in Big Query? I have tried every trick and tip in the book...and nothing works. The only thing that sort of worked was setting the enablefolding=false, but then an error occurs when trying to load to the data model.
Thanks in advance!
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.
3 Replies
- foodd
Community Champion
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.
