You’re offline. This is a read only version of the page.
20
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
@Futumpch1, you don't have to delete the table, you can just delete those keys.
Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com
@Futumpch1, make sure that your Dataverse tables don't have these columns Ord No, Prd No as Alternate Keys.
Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com
Ahmed,
Thank you for the question. The data is there in power query, when I run the import / refresh the lines with duplicate values are missing.
William
Hello, @Futumpch1 , are you missing the data in the Power Query or after it loaded into the Dataverse Table?
Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
