Solved: Can´t create a relationship between two columns be... - Page 3

KSveigaard · ‎08-17-2016

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 information (ig. type, format)

In file B: "product number", "sales date" and lots of sales data. (ig. units sold, units inventory) (Customer I)

In file C: "product number", "sales date" and lots of sales data. (ig. units sold, units inventory) (Customer II)

When linking / relationship - the "product number" I get this error message:

"You Can´t create a relationship between these two columns because one of the columns must have unique values."

Check with vlookup, in the excel´s files and there it is possible to find, the product number both ways.

All product numbers are formatted to number, so it should work - but dosent ???

ankitpatira · ‎08-17-2016

@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.

View solution in original post