Forum Discussion
Solved
Appending Two Tables - One With Incremental Refresh Policy, and One With Full Load
Apologies if this isn't the correct forum. I am at a loss with this issue. I have two queries: 1. All invoiced orders down to the line level for the last several years pulled from an Oracle d...
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.
Thanks for the response. Does it matter if I "Append" or "append as new?"
both are doing Append but Append as new will take a separate copy and append the data.