Forum Discussion
tbobolz
Resolver I
Resolver IIncremental refresh with no parameters advice
Hi All, I'm new to setting up incremental refreshes and I have read through microsoft's and other's instruction for setting these up. However in my case I have daily data being dropped to my gate...
- Hi there
Even though you set it to only go back one day, because it cannot do query folding it has to read all the data to find the last day.
Incremental refreshing is the right approach but it only works on data sources that can do query folding which is typically database systems
tbobolzResolver I
Resolver ISince I do not need it to read the past rows to look for a changes, I just want it to load the new daily data, should I be using a different refresh method?
Thanks
GilbertQ
Super User
Super UserHi there
Even though you set it to only go back one day, because it cannot do query folding it has to read all the data to find the last day.
Incremental refreshing is the right approach but it only works on data sources that can do query folding which is typically database systems
Even though you set it to only go back one day, because it cannot do query folding it has to read all the data to find the last day.
Incremental refreshing is the right approach but it only works on data sources that can do query folding which is typically database systems