Forum Discussion
Query folding in Snowflake DirectQuery is failing
Hi Anonymous ,
Are you using a native database query when connecting to Snowflake, and if so, there are some limitation on query folding:
Query folding while using a native database query is limited to the PostgreSQL connector only. No other connectors support query folding if you use a native database query. Also, for folding to work in the PostgreSQL connector, the native database query you enter has to work as a subquery.
Also, in this case below, it is mentioned that query folding does not work if there are arrays involved in the data source query.
Does Snowflake support query folding when used as a data source by Power BI?
Power BI Incremental Refresh with Snowflake
Best Regards
Anonymous Well then you answered your own question? View native query is present when query folding is occurring so if Snowflake doesn't support view native query then it doesn't support query folding...yes?
No...
if "View Native Query" is enabled, then query folding is working.
If "View Native Query" is disabled then you cannot draw any conclusions.