Forum Discussion
Incremental Refresh vs Default Refresh
Hi Anonymous Incrimental refresh is actually usefull for large data set in your particular case Incremental refresh has overhead for comparing and merging data, which isn't beneficial for small flat files like Excel and Default refresh reloads the entire file faster since Excel files are typically loaded in memory as a whole.
In Conclusion Incremental refresh is useful for large datasets where querying only recent changes reduces refresh time. For small flat files, stick to default refresh.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Super UserHi Anonymous Incrimental refresh is actually usefull for large data set in your particular case Incremental refresh has overhead for comparing and merging data, which isn't beneficial for small flat files like Excel and Default refresh reloads the entire file faster since Excel files are typically loaded in memory as a whole.
In Conclusion Incremental refresh is useful for large datasets where querying only recent changes reduces refresh time. For small flat files, stick to default refresh.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance