Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Data Model telling me there are duplicates I can't find

  1. #1
    New Member
    Join Date
    May 2018
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data Model telling me there are duplicates I can't find


    Data Model telling me there are duplicates I can't find
    Trying to make a connection from a data table to a lookup table. Everytime I do I get the following message: "The relationship cannot be created because each column contains duplicate values. Select at least one column that only contains unique values."

    I cannot find any duplicate values in the look up table column. I have even gone to the data source (excel worksheet) to run the delete duplicates function and it says no duplicates found. I also initially found an empty row in the table and deleted it and then reloaded the data. It showed one less row was loaded from before so that row is no longer in the data model but still getting the error. This is a text column to text column lookup. Help!

  2. #2
    Board Regular
    Join Date
    Apr 2015
    Posts
    356
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Model telling me there are duplicates I can't find

    Did you check for blanks? Did it bring in blank rows at the bottom, or between rows?

    Otherwise you could create a query that just returns the column you would expect to have no duplicates, create another query where you use the remove duplicates function, and then merge the two queries with an anti-join to see what is left.

  3. #3
    Board Regular
    Join Date
    Apr 2014
    Posts
    132
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Model telling me there are duplicates I can't find

    Also make sure when you eliminate duplicates in Power Query that you are turning off case sensitivity - PQ default is opposite that of Power Pivot.

    Example:

    xxx = Table.Distinct(PreviousStep, {Field Name, Comparer.FromCulture(Culture.Current, true)})

  4. #4
    New Member
    Join Date
    Sep 2016
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Model telling me there are duplicates I can't find

    I had a similar problem a while back. Have you tried cleansing for whitespace? Go to your excel table and wrap the column in =Clean(Trim(TextField)). I would then apply conditional formatting to the new column to highlight duplicates to see if it produces any results.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

DMCA.com