Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Creating relationships using Surrogate Key and Composite key

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?

1 REPLY 1
SandeepSugandh
Frequent Visitor

Ideally Dim table should not have duplicates. Have you tried craeting bridge table between fact and dim?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors