Incremental Refresh with PostgreSQL - Is query folding happening?

chad_oge 

According to the official doc, it is not recommend to use nonfoldable queries. Incremental refresh fordatasets in Power BI - Power BI | Microsoft Docs

" If you see this warning and want to verify the necessary query folding is occurring, use the Power Query Diagnostics feature or trace queries by using a tool supported by the data source, like SQLProfiler. If query folding is not occurring, verify the filter logic is included in the query being passed to the data source. If not, it's likely the query includes a transformation that prevents folding."

Reference:

Query folding guidance in Power BI Desktop - Power BI | Microsoft Docs

Query folding | Microsoft Docs

PaulZheng_ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.