Forum Discussion
Query regarding 'Detect data changes' option for Incremental Refresh
Hi everyone!
I have multiple dataflows in Premium capacity because we are looking to reduce the refresh time as much as possible, I turned on the Incremental refresh for most of the tables and I included the option of "Detect data changes"....
After setting the incremental refresh, the refresh history has been showing the same time they took prior to the incremental refresh or in some cases even more time 😞
Is it really worthy the incremental refresh with detect data changes option?
OData and OData Feed generally do support query folding: https://learn.microsoft.com/en-us/power-query/power-query-folding#sources-that-support-folding
7 Replies
Hello - have you ensured that query folding did not break due to one of your applied steps in Power Query? With Detect data changes, if you have it set to incrementally refresh the last two weeks of data it will only actually refresh anything new and anything in the last two weeks that has changed instead of the entire two weeks.
Hi audreygerred
how can I tell if one of the applied steps is causing this query folding to break?
thank you a lot!Right click on the step in Applied Steps and see is View native query is greyed out on any of them.
