Hi @avalon.ds,
That seems like an odd situation since what you are describing is standard Append Table functionality. However, it would be simple enough to test by enabling the load for the 2017 and 2018 tables and see if that causes the main table to refresh.
The answer to the second question appears to be “no, the data is not refreshed”. I keep all my reports on a network drive for dev work, refresh them manually as needed, then do a Save As to the report server to deploy them. The scheduled refreshes take over from there. I just tried your steps with an employee dashboard that I confirmed refreshed on the server over night, and the Last Refresh date/time I display in the Desktop was 4/29/19 which is when I last worked on it locally.
I do know that if I work on a report locally with non-refreshed data and then deploy it to the server, the server data will revert to whatever I had locally.
John C. Pratt
