Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsMedium
A company uses Power BI deployment pipelines to manage their reports. A developer has made changes to a report in the 'Development' stage. Before deploying to the 'Test' stage, the developer wants to ensure that the dataset's data source connection string is automatically updated from a development database to a test database. Which feature of deployment pipelines should be configured?
- ADataset refresh settings
- BParameter rules
- CPipeline permissions
- DDeployment rules for data sources
Show answer & explanationAnswer & explanation
Correct answer: D. Deployment rules for data sources
Deployment rules specifically allow you to configure how data sources, parameters, and other properties are modified when content is deployed between stages. Data source rules are used to automatically switch connection strings.
Why the other options are wrong
- A. Dataset refresh settings control when and how data is refreshed, not the data source connection itself during deployment.
- B. Parameter rules are for changing parameter values, not directly the underlying data source connection string.
- C. Pipeline permissions control who can perform actions in the pipeline, not how content is transformed during deployment.
Deployment Pipeline Data Source Rules
Deployment pipeline data source rules automate the modification of data source connection strings when content is deployed from one stage to another.
- Automate connection string changes
- Ensures correct environment targeting
- Configured per pipeline stage
Memory trick: The pipeline rules automatically route your data to the right place.