The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
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
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
36 | |
23 | |
23 | |
21 | |
16 |