Forum Discussion
Dataflows: Getting query folding error after changing to incremental refresh
I've got a dataflow that's pulling data from Snowflake and I've got reports connecting to that dataflow via DirectQuery. It's been running smoothly before, but yesterday I decided to change the d...
Hi， thedaxlearning
Please refer to Incremental refresh and real-time data for datasets.
Because support for query folding is different for different types of data sources, verification should be performed to ensure the filter logic is included in the queries being executed against the data source. In most cases, Power BI Desktop attempts to perform this verification for you when defining the incremental refresh policy. For SQL based data sources such as SQL Database, Azure Synapse, Oracle, and Teradata, this verification is reliable. However, other data sources may be unable to verify without tracing the queries. If Power BI Desktop is unable to confirm, a warning is shown in the Incremental refresh policy configuration dialog.
Best Regards,
Community Support Team _ Eason