Forum Discussion

KSveigaard's avatar
KSveigaard
Regular Visitor
10 years ago
Solved

Can´t create a relationship between two columns because one of the columns must have unique value

Hi    In Desktop Power BI, I have made a report, with 3 excel files, and want to make a link between these excel files,   In file A: I have the "poduct number", and lots of other product informat...
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    KSveigaard basically what that error is complaining about is that relationship you're trying to create from column within 'FROM' table to your column in 'TO' table has issue. one of that column must have unique product numbers. you can't have Many to Many relation but only One to Many or Many to One relation. So ensure that one of the table has unique product numbers and then there won't be any issue. 

LMorman's avatar
LMorman
Icon for Helper I rankHelper I
9 years ago

I am having hte same issue, but I do not understand what you mean by unique values,

Table A contains the name of a Sales Person and their Manager

Table B Contains the name of a Sales Person and their assigned Companies.

 

Why can't I connect the two tables on the sales person name so I can create a Matrix that shows the Manager name, sales person name and the sales person companies?

TristanKuesters's avatar
TristanKuesters
Icon for Resolver I rankResolver I
9 years ago
Unique means, that the sales person on one of the both tables should be not be double (or more) in several rows.
So check, if the sales person in the first table is only one in the table!
  • LMorman's avatar
    LMorman
    Icon for Helper I rankHelper I
    9 years ago

    Thanks.  I have been so frustrated with this.  I just went back and looked at my lookup table and a row got duplicated!  It now works!! 

    Lesson learned :)

     

    Thanks!!

  • tabrnx's avatar
    tabrnx
    New Member
    8 years ago

    what if in some cases you have header and lines situation. meaning a table captures information at header level with a unique id and another table captures information at line level with stamping the header id for each line to retrieve info in a single query. How do I manage one to many as I could have duplicated ids in one table based on design? please advise.

    • johanabarrera's avatar
      johanabarrera
      New Member
      8 years ago

      I got my data from Excel.   I'm sure that there is no blank and no duplicated row in this table, and order ascending the column and there are no nulls on TOP. Additionally, I used the option eliminate duplicates in Power BI and after that the option eliminates blanks. But I wasn’t able to make the data relationship.

      I checked in PowerBI Data View the data table and I have this:  “TABLE: table name (5.946 rows) COLUMN: column name (5.945 distinct values)”

       

      I don’t understand why I can’t make the data relationship. Can anybody help me? 

       

      • Polly's avatar
        Polly
        Icon for Helper I rankHelper I
        8 years ago

        I am having the same issue, I'm pull data from an R script where I state only to select unique non-null values and then have added a step in Power Query to replace nulls and blacks with "ISSUE ROW!" and then also remove duplicate rows - However I still cannot define the relationship