Given the need for up-to-date data on a daily basis and weekly revisions, the best approach is to use an incremental extract refresh daily to update the data source with new transactions. On Saturdays, when incorrect transactions are revised, a full extract refresh should be performed to incorporate all revisions and ensure the data's accuracy.This strategy allows end users to have access to the most current data throughout the week while also accounting for any necessary corrections12.
References:The solution is based on best practices for managing data sources in Tableau Server, which recommend using incremental refreshes for frequent updates and full refreshes when significant changes or corrections are made to the data12.