Relationships

In Power BI, relationships play a crucial role in connecting and establishing associations between different tables within a data model.

User Interface

1. From: Source table or entity in the relationship.

2. Relationship type: Type of association between tables (e.g., one-to-many/one-to-one/many-to-many).

3. To: Target table or entity in the relationship.

4. Active Relationship: (Yes/No) Indicates if the relationship is currently active or disabled.

5. Cross Filter Direction: Specifies how filters flow between tables in the relationship.

6. Assume Referential Integrity: (Yes/No) Assumption that foreign keys have valid references.

7. Apply Security Filter in both direction: (Yes/No) Security filters are applied in both directions of the relationship for data access control.

The "Apply Security Filter in both Directions" is available only when the Cross Filter Direction is "Both"