Power BI Detecting Many to Many Relationship in Table which contain unique Values

[gautampruthi]

Hi, 

I am joining two tables table a and table b
Table A Column Statistics

Count	108046
Error	0
Empty	0
Distinct	108046
Unique	108046
Empty string	0
Min	0000001
Max	ÿÿÿÿÿÿÿ

Table B Column Statistics

Count	48456
Error	0
Empty	0
Distinct	39562
Unique	32292
Empty string	0
Min	0000001
Max	FALAPIV

as shown above Table A has unique values and does'nt contain null values but still Power BI is detecting it as many to many.

[Anonymous]

Hi @gautampruthi ,

Can you show us your whole data or your pbix? No problem based only on the sample data you have provided.
Please note that during the join process you must make sure to select the count of the two tables to join.

Best Regards,
Dino Tao

[lbendlin]

you should be able to modify that to a 1:* from A to B.

Note that it is not recommended for dimension tables to have cardinality over 50000.