Forum Discussion

gautampruthi's avatar
gautampruthi
Helper II
2 years ago

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

Hi, 

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

Count108046
Error0
Empty0
Distinct108046
Unique108046
Empty string0
Min0000001
Maxÿÿÿÿÿÿÿ

 

Table B Column Statistics

Count48456
Error0
Empty0
Distinct39562
Unique32292
Empty string0
Min0000001
MaxFALAPIV

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.

Show and Tell
Tips and Tricks

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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