You’re offline. This is a read only version of the page.
69
Hi,
I have a simple XLSX data source containing 1837 Records (rows)
I create a Dataflow to create a New DVTable through Power Query containing (I checked) all 1307 Records.
The Dataflow includes:
>'Delete Rows No Longer in Query output"
>Auto-Generated Unique PRIMARY name column
>Alternative Key Column (in my XLSX Column the values are not unqiue).
I Publish the dataflow from PowerQuery. However the resulting newly created DVTable only contains 1830 records (Power Query showed 1837).
I have tried "refreshing" to no avail.
There are no errors or alerts of any kind (char limit or Type issues etc). I checked the Source XLSX and the missing Records are completely randomly spread with no apparent particular difference in record contents.
I have made fresh new attempts and it is always the same 7 records missing.
Any thoughts?
@JonathanDavey1, If you decide that your DataFlow will continuously run and update the Dataverse table, you have to have a Column in Dataverse that has Unique Values and set it as Alternate Key. This same Column must be in the Excel sheet with Unique values as well.
Note: Alternative key can be a combination of multiple columns if that will create the uniqueness in your Excel.
DataFlows will basically use the Alternate Key to compare the records between the Source and destination. So if you have an Alternate Key value exist multiple time in the source, it will only compare the first one and ignore the other records that have the same alternate key value.
I hope this make it clear.
| If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com
|
Thanks Ahmed, its a little confusing. "Unique Primary Name Column" DOESNT Have to be UNIQUE...
And Is the Feature Column that can generate an "Auto-generated" UNIQUE key TYPE.....
UnYet its the "Alternate Key Column" that does all the Work! I kinda get it, but really the Naming, Notes, attributes and behavours are muddling.
Hello, @JonathanDavey1 You mentioned >Alternative Key Column (in my XLSX Column the values are not unqiue).
Alternate Key Columns can't have Duplicate values.
So those 7 records probably duplicates.
| If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit 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 (
