Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsHard
A Power BI developer needs to implement a data source rule in a deployment pipeline to ensure that a dataset in the 'Test' stage connects to the 'Test_Database' SQL Server instance, while the 'Production' stage connects to the 'Prod_Database' SQL Server instance. The data source type and credentials remain the same. Which of the following properties should the developer configure in the deployment pipeline rule for the data source?
- ADatabase server, Database name
- BGateway connection, User credentials
- CQuery parameters, Table names
- DReport layout, Visual filters
Show answer & explanationAnswer & explanation
Correct answer: A. Database server, Database name
When configuring data source rules in a Power BI deployment pipeline, the properties that typically change between environments are the database server name and the database name. By mapping these properties, the pipeline can automatically redirect the dataset to the correct environment-specific database instance during deployment.
Why the other options are wrong
- B. Gateway connection and user credentials are usually managed separately in the data source settings within the workspace, not typically as part of a deployment rule for switching environments.
- C. Query parameters and table names are part of the dataset's data model or queries, not direct data source connection properties managed by deployment rules for environment switching.
- D. Report layout and visual filters are report-level elements and are not part of data source connection rules in deployment pipelines.
Deployment Pipeline Data Source Rule
A deployment pipeline data source rule maps data source connection properties (like server and database names) between stages, allowing datasets to automatically connect to environment-specific data sources during deployment.
- Automates data source switching
- Configured per stage for datasets/dataflows
- Typically maps server and database names
- Ensures environment-specific connections
Memory trick: Map the server and database to connect the right source.