Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello Community,
Good Day!
I am really stuck with a question in my head.I have watched several videos but didnt get this answer.
Suppose I have 2 tables (1 dimension and other fact table) so how should i create a perfect relationship between them if they both have duplicates.
Shall I create a composite keys in both the table and join them or shall i remove duplicates from the dim table,create a surrogate key then join the dim table and fact table using common identifier and then include the surrogate key inside fact table to create active relationship between dim and the fact table using surrogate key?
Ideally Dim table should not have duplicates. Have you tried craeting bridge table between fact and dim?