Power Pivot - Can't create relationship - No dublicates???
Attached is an excel document with two tables loaded into a power pivot data model. I am trying to create a relationship between the stock code field in each table. I have used conditional formatting to check for duplicates in the supplier table stock code column and can't find any. Yet when I try and create a relationship I am getting the many-to-many error.
Can anyone double check for me, perhaps I'm missing something.