Include in Report Refresh - need to optimize the loading of data

Hello!

I have a model connected to an access data base with data for several years. The problem is that every time that I need to refresh the data (on a weekly or even daily basis) it takes even an hour and a half. What I did is to duplicate the table and filter by date this way:

1. table 1: "until October 2020"

2. table 2: "from October 2020 on"

I then did an annex of both tables and unchecked the option "Include in Report Refresh" of the table 1 and the "Enable Load" of both tables (1 and 2) but not the Annex. It is not really working as the Annex still needs to load every row of both tables. Do you have any solution so the historical data does not need to be loaded every time? Thanks!