I have a similar situation here too. Initially, I had scheduled a daily refresh, but then later changed it to a weekly refresh to avoid overloading the database and Tableau servers.
In a worst case scenario, your data may not get updated for 7 days, but will be updated on the 8th day.
Yep, unfortunately that won't work here. Business Ops wants the data asap once it has been validated. I had to push to get them to do a once a day update.
I'm thinking of doing something like run it nightly from the 15th - 25th. But trying to save on load if possible.
Sure. That will work too.