Powerops
  • Introduction to Powerops
    • Features
    • Use-Cases
    • Advantages
    • Powerops Desktop vs Powerops SaaS
    • Get Started
      • How to Create an Account on GitHub?
      • How to Create an Account on Azure DevOps?
      • How to Create a new Repo in Powerops?
      • How to Register on Powerops?
  • Analyze
    • Overview
      • Importance
      • Features
      • User Interface
    • Summary
    • Report
      • Pages
      • Visuals
      • Custom Visuals
      • Filters
      • Bookmarks
      • Actions
      • Sync Slicers
      • Navigators
    • Model
      • Tables
      • Columns
      • Hierarchies
      • Parameters
      • Data Groups
      • Data Sources
      • Relationships
      • Refresh Policies
      • Perspectives
    • DAX
      • Measures
      • Calculated Columns
      • Calculated Tables
      • Calculation Groups
      • KPIs
      • DAX Query View
      • Visual Calculations
    • Dependencies
      • Model Dependencies
      • Report Dependencies
    • M Queries
    • Roles
      • Row-Level Security (RLS)
      • Object-Level Security (OLS)
    • Info
  • Best Practices
    • Overview
    • Report Rules
      • System Rules (Report)
      • Edit Rules
        • ROM (Report Object Model)
        • Modify Existing Report Rule
        • Create New Report Rule
        • Report Rule Expression
    • Data Model Rules
      • System Rules (Data Model)
      • Edit Rules
        • TOM (Tabular Object Model)
        • Modify Existing Rule
        • Create New Rule
  • Data Security
    • Data Security Review
    • SOC2 Certification
  • INSTALLATION
    • Adding a License Key
  • Release Notes
    • Version 1.0.0
    • Version 1.2.1
    • Version 1.3.0
    • Product Roadmap
  • GENERATE DOCUMENTATION (PRO)
    • Importance of Documenting Power BI Reports
    • Step-by-Step Guide
Powered by GitBook
On this page
  1. Analyze
  2. Model

Relationships

Last updated 1 year ago

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"