Query Folding in Big Query

[Jhamed]

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!

[foodd · Accepted solution]

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.

Incremental refresh in #PowerBI with data from BigQuery 

[Jhamed]

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!

[foodd]

@Jhamed , I am happy that it helped.