PL-300 Live connection Practice Question
You are building a Power BI report that uses a live connection to an Azure Analysis Services (AAS) tabular model. Users need to be able to filter data using a slicer that shows only products that have been sold in the current year. What should you do?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create a calculated table in the AAS model that returns only products sold in the current year
A calculated table in the AAS model can be created using DAX to dynamically return only products sold in the current year (e.g., using FILTER, CALCULATETABLE, YEAR, and TODAY functions). This table is available in Power BI via live connection and can be used as the slicer source. Option A is wrong: a calculated column in the Product table is static at process time and does not dynamically filter to current year; it also adds a column to the entire table, not a subset. Option B is wrong: a visual-level filter on the slicer relies on the underlying data model; with live connection, you cannot create new tables in Power BI Desktop, and filtering on a date condition would require the slicer to use a field from a different table, which is not straightforward or recommended. Option D is wrong because live connections to AAS do not allow creating calculated tables in Power BI Desktop; all data modeling must be done in the source model.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add a calculated column to the Product table in the AAS model that marks products sold this year
Why it's wrong here
A calculated column is static and would not dynamically filter for the current year; it would require manual update or refresh of the model.
- ✗
Use a filter on the slicer visual to show only products where sales year equals current year
Why it's wrong here
A filter on the slicer visual affects the data shown in other visuals, not the items listed in the slicer itself.
- ✓
Create a calculated table in the AAS model that returns only products sold in the current year
Why this is correct
A calculated table in the AAS model can use DAX to dynamically return only products sold in the current year, and it will be available in the live connection.
- ✗
Create a calculated table in Power BI Desktop using DAX to filter products
Why it's wrong here
Live connections do not allow creating new calculated tables in Power BI Desktop; you must create them in the source model.
Go deeper
Related to this question
About these practice questions
One of 217 original PL-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.