So,
I have two tables one order headers with an date and Order Number and another order lines with the items on the order in a sql database.
I can get the most recent orders and refresh those incrementally. However as there is no date on the Order Lines I have added the date as Column using Power Query. A left Merge and then expanding. This works up to a point and I get missing lines on upload to dataverse that are there in the powerquery table I have created.
Order Header
Ord No, Date
Order Lines
Ord No, Prd No, Qty, Bin
Merged Table
Ord No, Prd No, Qty, Bin, Date
The data that is being missed on upload is when there are duplicate values for Ord No, Prd No.
Any idea on how i can ensure all rows are added to the dataverse table?
Many thanks
