Title: PL-300 Practice Question – Where to Modify Relationships in Power BI Desktop
When you’re building a Power BI semantic model, understanding where to define and adjust relationships between tables is fundamental — both for the PL-300 exam and for real-world report building.
📌 Question:
You have begun creating a Power BI Semantic model by connecting to a SQL Server database with multiple tables.
You now need to modify the relationship between the tables.
Which interface should you use in Power BI Desktop? (Select only one answer)
- Table view
- Model view
- DAX query view
- Report view
✅ Correct Answer: 2. Model view
🧠 Why Model View is the Correct Choice:
- Model View in Power BI Desktop gives you a diagram-like interface showing all tables in your semantic model.
- It allows you to:
- View existing relationships.
- Create new relationships by dragging fields between tables.
- Edit relationship properties (cardinality, cross-filter direction, etc.).
- Delete relationships if needed.
Without the correct relationship setup, aggregations, filtering, and DAX measures can produce incorrect results.
🚫 Why the Other Options Are Incorrect:
1. Table View
- Lets you see raw data from a table.
- You can’t create or edit table relationships here.
3. DAX Query View
- Used for writing and testing DAX queries.
- Not intended for visual relationship editing.
4. Report View
- Used to build visuals, dashboards, and reports.
- Relationships must already be defined before the Report View can interpret cross-table filtering correctly.
📌 Pro Tip for PL-300:
If the question involves relationships, cardinality, or model diagram editing, the answer is almost always Model View.
In the exam, remember this mental shortcut:
Relationships live in the Model View — not in data tables, queries, or reports.