Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Poweraegg
Advocate IV
‎02-04-2025 09:00 AM

Connecting Fact Tables in Microsoft Fabric: A Bridge Table Guide to Eliminate Duplicated Dimensions

 

In complex data models, multiple fact tables often share common dimensions (e.g., Date, Customer). Duplicating these dimensions leads to bloated schemas and maintenance headaches. This guide shows you how to solve this problem in Microsoft Fabric using a bridge table—a lightweight, key-only connector that centralizes relationships.

 

Why a Bridge Table?

  • Problem: Traditional star schemas force duplicated dimensions when facts share context.
  • Solution: A bridge table sits at the center of your model, storing only keys to link facts and dimensions.

Step-by-Step Implementation

  1. Design in Lakehouse:
    • Use Fabric Lakehouse to transform data upstream for efficiency.
    • Create fact/dimension tables and extract keys.
  2. Build the Bridge with Dataflow Gen2:
    • Use queries to join keys (e.g., FactSales + FactResellerSales → BridgeTable).
  3. Configure Relationships in Power BI:
    • Establish many-to-many links from bridge to facts (bidirectional).
    • Establish one-to-many links from bridge to dimensions (bidirectional).
    • Mitigate performance issues with aggregations.

Best Practices

  • Keep the bridge table lean (keys only).
  • Document relationships to avoid circular dependencies.

Limitations

  • Bidirectional relationships are unavoidable but manageable with careful DAX.

Conclusion
Bridge tables streamline your Fabric data models, reduce redundancy, and improve scalability. Try the bridge table approach today and let me know how it works for you!

0
Comments
Advocate III
‎02-05-2025 01:30 PM

Great post on the use of bridge tables! Thanks for sharing!

Advocate IV
‎02-06-2025 12:32 AM

@shannonrlindsay thanks!

0
Wednesday

Hi Team,
I have recently learnt Microsoft Fabric, and the requirement is to migrate our existing power BI reports to Microsoft Fabric.
Can anyone help me with some suggestions / steps to achieve this goal.

Expecting a helpful answer.
Thanks

0
Advocate IV
Friday

Hi @Shubham_01,

what are your requirements? Migrating reports is not necessary, switching to a Fabric tenant should be seamless. Can you give more detail?

 

BR 

0