Forum Discussion
Primary Key Duplicate Detection in Data View, not Power Query
Can you give us a data sample please and indicate what your desired result is?
As far as I know, for text fields, leading spaces are preserved but trailing spaces will be removed automatically.
Hi mate,
Thanks for coming back to me - apologies for the delayed response.
I've listed an example below:
Contact Code A: 0544
Contact Code B: 544
Image from System:
The above are detected as unique values in Power Query but, when I run a dax query to locate distinct values, one of the two is removed. Second to that, PBI is picking them up as duplicates when I attempt to create the relationship with another table as its defaulting to Many-to-Many and won't allow a One-to-Many.
Example 2:
Contact Code A: "DUCKWORTH"
Contact Code B: "DUCKWORTH "
Image from system:
Also, I've tested creating a calculated table summarizing several columns based on account code which has allowed me to create a One-to-Many relationship. This still isn't my ideal solution as this means that several of those duplicate values have been removed when they are, in fact, unique in the database.
I understand that they are duplicates but its possible for each to have unique information stored against it.
Thanks in advance for your help.
HotChilli - just realized I forgot to tag you so I'm not sure you saw my response.