Appending Two Tables - One With Incremental Refresh Policy, and One With Full Load

Hi Dave1mo1 ,

It might be becuase the incremental setting is not transferred to the appended table. So, in Power query, it takes that filtered data.ie., the between RangeStart and RangeEnd dates.

In this case, just try the below steps that may work.

1. Take a reference from your second table that requires full refresh

2. then append your first table (incremental refresh table) with the referenced table taken in #1

3. then apply the incremental refresh on that appended table.

Thanks.

both are doing Append but Append as new will take a separate copy and append the data.