Forum Discussion
Incremental Refresh didn't save time
- Hi there
It would then appear that both of those data sources do not support query folding.
Which means that it has to load all the data first, and then determine which data to load incrementally. In doing it in this manner it will not be any quicker using incremental refreshing.
Thanks for the information. I applied incremental refresh for dataflow. But it shows the same warning as Snowflake: unable to confirm if the m query can be folded it is not recommended to use incremental refresh with non-foldable queries
Do you know what kind of data source support query folding?
Thanks,
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#limitations
If you read further up it says it should display the warning.
Are both the snowflake and the dataflow used in the same PBIX?
No. I tried the same pbix file with two data sources and they both didn't work.
Hi Anonymous
I am fairly certain that if you are combining the 2 data source that the incremental refreshing process has to load all the data before it can incrementally load the data.
And that is why you are not seeing it saving any more time.
What happens if you try them individually?
Hi GilbertQ ,
Thank you for your advice. I didn't make it clearly. I use dataflow and snowflake individually for incremental refresh and they both didn't work.
Thanks,
- Hi there
It would then appear that both of those data sources do not support query folding.
Which means that it has to load all the data first, and then determine which data to load incrementally. In doing it in this manner it will not be any quicker using incremental refreshing. - No worries, glad to help
Incremental refreshing can be a bit of a challenge at times that is for sure. But when it works, it works really well!