Forum Discussion
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 Count 108046 Error 0 Empty 0 Distinct 108046 Unique 108046 Empty string 0 Min 0000001 Max ...
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.