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