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. 

anguyen83's avatar
anguyen83
Frequent Visitor
9 years ago

Hi

 

I am new to powerBI. I've spent years using MS Access and now moving into this system is all foreign to me.

 

I have two tables which I am trying to link

 

Date from activities2 table: Date Table which format is (dd mmmm yyyy) 

 

tbl_Date from tbl_dates table: Date Table which format is (dd mmmm yyyy)

 

I want to link both tables and return the field called dt_Friday_WE which is a marker that groups the date field into categories

 

But I am getting the same error. If I was using access then i am able to do a 1:1 join. However PowerBI works differently

 

Can someone help?