If you're going to use an incremental refresh you need a field that will reliably identify from where the next refresh should begin - i.e. an incremental ID field or a date - plus you also need to be sure that everything that happened prior to that ID or date hasn't changed. Data where the past can change isn't suitable for an incremental refresh. Business AnalyticsWhen is it suitable to use an incremental extract with Tableau Server
A strategy I have seen where some data changes historically but not enough to change the high level message is incremental extracts throughout the week and a full refresh at the weekend.