PL-300 Visualize and analyze the data Practice Question
You have a report that uses a live connection to a Power BI dataset. You want to add a table visual that shows sales by product, but you notice that you cannot add a calculated column. What is the reason?
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
✓
Live connections do not support calculated columns; they must be created in the source dataset.
The correct answer is D: with a live connection to a Power BI dataset, the report is bound directly to the published dataset's model, so calculated columns cannot be authored in the report and must instead be created in the source dataset (using Power BI Desktop or the dataset's modeling features). This is because live connections only allow report-level visuals and measures, not modifications to the underlying tabular model. Option A is incorrect because row-level security is unrelated to preventing calculated columns. Option B is incorrect because table visuals are fully supported over live connections. Option C is incorrect because there is no 'Allow calculations' setting in dataset settings that enables calculated columns for live-connected reports.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Live connections require row-level security which prevents calculated columns.
Why it's wrong here
Row-level security (RLS) filters rows based on user context at query time; it is enforced by the dataset and does not restrict DAX authoring features. The real reason calculated columns are unavailable is that a live connection is read-only: you cannot add or modify any schema objects locally, regardless of RLS settings. Conflating security with modeling constraints is a common mistake.
- ✗
Table visuals are not supported with live connections.
Why it's wrong here
Live connections support all native table visuals, including tables, matrices, and charts; the report simply renders the results returned by the source model. Unlike imported models, the visual's performance depends on the source server's query engine, but there is no visual-type limitation imposed by the connection mode. This option incorrectly assumes that read-only connections affect rendering capabilities.
- ✗
You need to enable 'Allow calculations' in the dataset settings.
Why it's wrong here
A live connection creates no local dataset or storage, so there is no 'Allow calculations' toggle to enable for it. Calculated columns are not possible because the local model is read-only; even if such a setting existed, it would not grant write access to the source. In contrast, DirectQuery does permit some local calculations, which might be what this option is confusingly referencing.
- ✓
Live connections do not support calculated columns; they must be created in the source dataset.
Why this is correct
Live connections connect the report directly to an existing Power BI dataset or Analysis Services tabular model and expose only the model objects already defined there. Calculated columns are schema-level objects that require a storage engine and a row context to compute; the live connection provides neither, so they cannot be created inside the report. The fix is to add the column in the source semantic model and then refresh the report's metadata.
Go deeper
Related to this question
About these practice questions
One of 524 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.