PL-300 Deploy and maintain assets Practice Question
You need to deploy a Power BI report from a development workspace to a production workspace. You want to ensure that the report uses the production dataset connection string without manual changes. What should you use?
⚠ Common exam trap
It's easy for candidates to confuse manual post-deployment updates (options A and D) or template-based approaches (option B) with the automated, rule-based override mechanism provided by deployment pipelines, which is the only method that meets the 'no manual changes' requirement.
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
✓
Configure a deployment pipeline with parameter rules to override the data source.
Deployment pipelines in Power BI allow you to define parameter rules that automatically override data source connection strings when content is deployed from development to production. This ensures the report uses the production dataset without any manual post-deployment changes, maintaining consistency and reducing human error.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Manually update the data source in the production workspace after deployment.
Why it's wrong here
Manually updating the data source in the production workspace after deployment introduces human error risk and violates the requirement for zero manual changes, as the stem explicitly demands that the report automatically use the production dataset connection string. This approach is tempting because it is a straightforward, one-time fix for a broken connection after deployment, and it would be the correct choice if the scenario allowed for a single, controlled manual adjustment rather than requiring an automated, repeatable deployment pipeline.
- ✗
Use a Power BI template (.pbit) and change the connection string before publishing.
Why it's wrong here
Using a .pbit template does not automate the connection string change; you would still have to manually edit the connection string in Power BI Desktop before each publish. That manual step is error-prone, does not scale across environments, and fails the requirement for a zero-touch, repeatable deployment. A .pbit is a project template, not a deployment artifact, so it provides no built-in mechanism for environment-specific substitutions.
- ✓
Configure a deployment pipeline with parameter rules to override the data source.
Why this is correct
Power BI Deployment Pipelines allow you to assign parameter rules (e.g., for data source parameters like Server and Database) that override values automatically when content is deployed from dev to test to production. This is the correct choice because it is the only option that truly meets the requirement of the report automatically using the production connection string without any manual adjustment. The rules are configured once in the pipeline and then applied consistently on every deployment, making the process repeatable and governed.
- ✗
Publish the report directly to the production workspace and update the dataset.
Why it's wrong here
Publishing directly to the production workspace and then updating the dataset after the fact is a manual, post-hoc fix that violates the requirement for an automated deployment. You would have to locate the dataset in the Power BI service, change the connection string manually, and ensure credentials are configured correctly—all of which introduces human error risk and is not repeatable. Additionally, this approach bypasses the deployment pipeline, so you lose the ability to validate the report in test/QA environments before production, and any future updates would require the same manual correction each time.
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 →
Same concept, more angles
1 more way this is tested on PL-300
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Which THREE steps should you perform to deploy a Power BI solution from development to production using deployment pipelines?
hard- A.Create a new workspace manually in production.
- ✓ B.Set up deployment pipeline rules to modify parameters (e.g., database name).
- C.Assign Power BI Pro licenses to all developers.
- ✓ D.Deploy content from development to test, then to production.
- ✓ E.Create a development workspace and add content.
Why B: Deployment pipeline rules allow you to modify dataset parameters (e.g., database server or database name) when content moves between pipeline stages, ensuring each stage connects to the appropriate data source without manual reconfiguration. This is a core feature of Power BI deployment pipelines to maintain environment-specific settings.
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.