What is a one-to-many relationship in Power BI?
A one-to-many relationship connects one record in a table to many records in another table. For example, one customer can have many orders.
What does a many-to-many relationship mean in Power BI?
It means records in one table can relate to many records in another table, and vice versa. For example, many students can enroll in many courses.
How does Power BI handle many-to-many relationships?
Power BI uses a special relationship type or a bridge table to manage many-to-many relationships, ensuring data aggregates correctly.
Why is it important to set the correct relationship direction in Power BI?
Because it controls how filters flow between tables, affecting calculations and visual results.
What is a common real-life example of a one-to-many relationship?
One store has many products. The store is the 'one' side, and products are the 'many' side.
In Power BI, a one-to-many relationship means:
One-to-many means one record in one table connects to many records in another.
Which method can Power BI use to handle many-to-many relationships?
A bridge table helps Power BI manage many-to-many relationships correctly.
What does filter direction control in Power BI relationships?
Filter direction controls how filters apply across related tables.
Which relationship type is best for connecting customers to their orders?
One customer can have many orders, so one-to-many fits best.
Many-to-many relationships in Power BI require careful handling because:
Many-to-many relationships can create ambiguous filters, so Power BI needs special handling.
Explain the difference between one-to-many and many-to-many relationships in Power BI with simple examples.
Describe why filter direction matters in Power BI relationships and how it affects report results.