Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsHard
A data analyst has created a Power BI report and dataset in a development workspace. After thorough testing, the report is ready for deployment to the production environment. The production environment has different data source credentials and parameter values (e.g., database server names). How should the analyst ensure these settings are automatically updated during the deployment process to avoid manual configuration errors?
- ASave the report as a Power BI Template (.PBIT) and manually update the parameters during import.
- BConfigure deployment rules within a deployment pipeline for data sources and parameters.
- CEmbed the production credentials directly into the Power BI Desktop file before publishing.
- DManually update the data source settings and parameters in the production workspace after deployment.
Show answer & explanationAnswer & explanation
Correct answer: B. Configure deployment rules within a deployment pipeline for data sources and parameters.
Deployment pipelines allow configuring deployment rules for data sources and parameters. These rules automatically apply the correct settings for each stage (e.g., Development, Test, Production) during content promotion, preventing manual errors.
Why the other options are wrong
- A. A .PBIT file helps with template creation but doesn't automate the application of different parameters for different environments in a deployment pipeline context.
- C. Embedding production credentials is a security risk and not a best practice for managing environment-specific settings.
- D. Manual updates are prone to errors and are exactly what deployment pipelines aim to avoid.
Deployment Pipeline Rules
Deployment pipeline rules in Power BI enable automatic modification of data source connections and parameter values when content is promoted between deployment stages (Dev, Test, Prod).
- Automate environment-specific configurations.
- Prevent manual errors during deployment.
- Support data source and parameter rules.
Memory trick: Rules Route Resources Right.