1 Relationships in Power BI Flashcards
What is the critical role of relationships in Power BI?
Ensuring data integrity and enabling meaningful analysis
What is a fundamental aspect of data modeling in Power BI?
Relationships
How does Power BI automatically detect relationships?
By looking for matching column names and data types, and considering the uniqueness of values
What is a benefit of automatic relationship detection?
Convenience for beginners or simple data models
What is a limitation of automatic relationship detection?
It may fail in situations with multiple columns having similar names or mismatched data types
What indicates an inactive relationship in Power BI?
Dashed lines
When should you disable automatic detection of relationships?
When you want more control over your data model in complex scenarios
What is the purpose of the ‘Relationship View’ in Power BI Desktop?
To provide a visual representation of the relationships between tables
How can you create relationships in Power BI?
By dragging and dropping a column from one table onto a related column in another table
What is a primary key?
A unique identifier in a table
What is a foreign key?
A column that refers to primary keys in other tables
Why is matching data types important when establishing relationships?
To ensure proper linking of related columns
What is one-to-many cardinality?
One row in a table is related to many rows in another table
What is one-to-one cardinality?
One row in a table is related to only one row in another table
What is many-to-many cardinality?
Multiple rows in one table can be related to multiple rows in another table, requiring a bridge table
What does single cross-filter direction mean?
Filters propagate in one direction only, from the ‘one’ side to the ‘many’ side
What does both cross-filter direction mean?
Filters propagate in both directions
How do relationships help maintain data integrity?
By enforcing referential integrity
How can well-defined relationships improve performance?
By optimizing how data is retrieved and filtered
What user experience benefit do relationships provide in reports?
Enable interactive filtering and slicing
