Forum Discussion

Thigs's avatar
Thigs
Icon for Helper IV rankHelper IV
4 years ago

Many to Many - No Duplicates?

Hey all,  I'm working with a new data set that comes from Excel. It has one column for SKUs as a unique identifier. I am trying to link it to a second dataset that has SKUs but not as a unique ident...
Need Help
Thigs's avatar
Thigs
Icon for Helper IV rankHelper IV
4 years ago

Hi! Thanks for the tip - unfortunately, no, this can't be the problem, as all the SKUs are numeric only, which can't have case sensitivity. 

Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
2 years ago

Hi Thigs, try to do the following:

  1. Load your data to PowerBI
  2. go to "Table view", select the table you need and look at column profile
  3. Do you have the same value in number of rows for "Table" and SKU "column"? If not, create a table visual with 2 columns: SKU and Count SKU, then sort it in descending order by SKU number to find the duplicate

If it doesn't help, please send us some statistic of your both dimensional and fact tables as well as details of the column you use as a key (like in the screenshot above).

Could it be that you have any other relationship in your data model that doesn't allow you to create one-to-many relationship?