Hi Thor
Welcome to Q&A Forum; this is a great place to get support, answers, and tips.
Thank you for posting your question; I'll be more than glad to help you out.
There is at least one option to resolve your problem, but that is (might be) a significant impact for you and your environment to prepare for...
Change the database structure to partitioning on that big table(s).
If you partition your table(s), you are able to run the "full" refresh only on the last partition of your data... depending on the partitioning key and size... that latest partition might only include the last day, week, month, or quarter...
Also, your queries/reporting might benefit from this change, as the query also just uses the last partition for querying, as SQL Server "knows" about those partitions and creates an execution plan according to the required date range.
I hope my answer is helpful to you,
Your
Bjoern Peters
If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!