Column Item no in Table Product contains a duplicate value '100-Product1'

[bzeeblitz]

While creating new relationship im getting error Column Item no in Table Product contains a duplicate value '100-Product1'  and this is not allowed for columns on the one side of a one-many relationship for columns that are used a s the primary key of a table.

Product

Item no product details  vendorname

Order

Itemno  ordername orderdate

caridnality i choosed one to many ,cross filter direction single and i got above error.

Actually im trying to create list report by pulling data after applying relationship

[Tahreem24]

@bzeeblitz As per the error message your shared, it seems like a your column (one side) has duplicate records. In order to have one-many relationship, Primary table column (One side) must have unique records, if not you can remove duplicates records or create a bridge table with only unique records then then connect both the tables with this newly bridge table.

[bzeeblitz]

One table contains 85000 records and i would appreciate if you could explain with sample screenshot of steps for bridge table as im new to this power bi reports

[Tahreem24]

@bzeeblitz  Create a new table like below:

Bridge Table = DISTINCT(Table[ColumnName])

Note: Use the column name which you want to make the key to connect between your tables.

Then Connect TableA with BridgeTable & BridgeTable to TableB.

[bzeeblitz]

Thanks i created bridge table

how to then Connect TableA with BridgeTable & BridgeTable to TableB.

[Tahreem24 · Accepted solution]

@bzeeblitz Here is the example. 

[bzeeblitz]

Yes im able to create as mentioned so now i need to create a list report where i need to show different columns from order and product table so how to generate report for the same