Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsHard
A Power BI developer wants to promote a report from a 'Test' workspace to a 'Production' workspace using a deployment pipeline. The 'Test' workspace uses a different database server for its dataset compared to the 'Production' workspace. What must be configured in the deployment pipeline to ensure the report connects to the correct database in 'Production'?
- AObject-Level Security settings
- BRow-Level Security rules
- CPower BI App audience settings
- DDeployment pipeline rules
Show answer & explanationAnswer & explanation
Correct answer: D. Deployment pipeline rules
Deployment pipeline rules allow you to configure specific settings that change when content is promoted between stages. Data source rules are critical here, enabling the dataset to automatically point to the correct database server (e.g., test.database.windows.net vs. prod.database.windows.net) when deployed to the Production stage.
Why the other options are wrong
- A. OLS hides tables/columns; it does not manage data source connections.
- B. RLS filters data rows; it does not change data source connections.
- C. Power BI App audience settings control who can view the app, not which database the underlying dataset connects to.
Deployment Pipeline Rules
Configuration settings within Power BI deployment pipelines that allow modifications to data source connections, parameters, and RLS during content promotion between stages.
- Applies during content promotion.
- Includes data source and parameter rules.
- Ensures stage-specific configurations.
Memory trick: Rules guide the pipeline's moves.