# Power BI Deployment Pipeline Checklist

> Application lifecycle management & staging in Power BI; deploy content, view deployment history & set up a mature Power BI ecosystem.

- URL: https://data-goblins.com/deployment-pipeline-checklist
- Author: Kurt Buhler
- Published: 2023-12-15
- Topic: Admin and governance

# POWER BI DEPLOYMENT PIPELINES

*Application lifecycle management & staging in Power BI; deploy content, view deployment history & set up a mature Power BI ecosystem.*

---

[BACK TO OTHER CHECKLISTS](/checklists)

---

## DATA GOBLINS POWER BI DEPLOYMENT PIPELINE CHECKLIST

**Version X.X - Update-in-progress: March 2024**

If you are setting up a Deployment Pipeline for the first time, or auditing an existing one, the below checklist helps you figure out what to consider:

**Click the question mark (?) for a link to a reference document.** This will be learn.microsoft.com documentation; if none are available, this may be a Data Goblins article, or another blog post reference.

### Planning

Deployment Pipeline planning & decision-making; this is always done.

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-0" class="checklist-checkbox">
Clarify the purpose & scope of the Deployment Pipeline; what is it used for, why is it needed? <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-overview" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-1" class="checklist-checkbox">
Assess which Azure AD group is used for access, or if a new one is needed <a href="https://learn.microsoft.com/en-us/power-platform/admin/control-user-access" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-2" class="checklist-checkbox">
Decide who has access to each stage of the pipeline (permission model) <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-best-practices#plan-your-permission-model" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-3" class="checklist-checkbox">
Define conditions content must meet to enter Test and Production <a href="#footnotes">[1]</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-4" class="checklist-checkbox">
Define when a deployment pipeline should be initiated, and by whom <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-best-practices#manage-who-can-deploy-to-production" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-5" class="checklist-checkbox">
Define a process to refresh datasets & update the Production App, since this isn't done automatically <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-best-practices#update-the-production-app" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-6" class="checklist-checkbox">
Plan if a Workspace App is also needed for Development & Test <a href="#footnotes">[2]</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-7" class="checklist-checkbox">
Define if & how linked content via cross-workspace publishing is managed <a href="https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-8" class="checklist-checkbox">
Define if endorsement will be used for 'Production' workspaces <a href="https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-endorse-content" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-9" class="checklist-checkbox">
Configure Version Control for the Development Workspace <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-best-practices#version-control-for-pbix-files" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-10" class="checklist-checkbox">
Document & share the way of working with the Deployment Pipeline across team members <a href="#footnotes">[3]</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-planning-11" class="checklist-checkbox">
Design a process to handle reversion or roll-back (i.e. with Version Control)
</label>

### Basic Setup

Initial steps always required to create and configure a Deployment Pipeline; mandatory items.

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-basic-setup-0" class="checklist-checkbox">
Pipeline follows tenant naming conventions; clear, concise, not redundant <a href="https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-workspaces-tenant-level-planning#workspace-naming-conventions" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-basic-setup-1" class="checklist-checkbox">
Pipeline has a concise & helpful description (i.e. declaring SPOC, Scope, linked pipelines/workspaces)
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-basic-setup-2" class="checklist-checkbox">
The appropriate AD Groups & members have been added
</label>

### Advanced Setup

Additional configuration sometimes done to facilitate more advanced Application Lifecycle Management (ALM) options.

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-advanced-setup-0" class="checklist-checkbox">
Data Source deployment rules configured, if necessary <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-get-started#create-a-deployment-rule" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-advanced-setup-1" class="checklist-checkbox">
Parameter deployment rules configured, if necessary <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-get-started#create-a-deployment-rule" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-advanced-setup-2" class="checklist-checkbox">
Integration into Azure DevOps or GitHub actions <a href="https://data-marc.com/2021/06/04/integrate-power-bi-deployment-pipelines-with-azure-devops/" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-advanced-setup-3" class="checklist-checkbox">
Schedule automated deployments, or link them to upstream pipelines/triggers <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-automation" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-advanced-setup-4" class="checklist-checkbox">
Link related deployment pipelines (i.e. data & reporting pipelines) <a href="#footnotes">[4]</a> <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-automation" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-advanced-setup-5" class="checklist-checkbox">
Configure pipeline dependencies & up/downstream actions (i.e. automated testing) <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-automation" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

### Monitoring

Optional steps taken to monitor Deployment activity & history.

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-monitoring-0" class="checklist-checkbox">
Create & follow a process to review the deployment history regularly <a href="https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-history" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-monitoring-1" class="checklist-checkbox">
Capture & log the deployment history using the REST APIs <a href="https://learn.microsoft.com/en-us/rest/api/power-bi/pipelines/get-pipeline-operations" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

## DEPLOYMENT PIPELINE DOCUMENTATION CHECKLIST

Documentation for Deployment Pipelines should mostly be focused on the process & way-of-working; it should be connected to the team's overall DataOps methodology. A Deployment Pipeline brings no value if the team, for example, deploys directly to Production for "hot fixes".

### Deployment Pipeline Documentation

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-deployment-pipeline-documentation-0" class="checklist-checkbox">
Basic info: Name, ID (for API use), SPOC, Scope, etc.
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-deployment-pipeline-documentation-1" class="checklist-checkbox">
Way of Working: DataOps / ALM process & permission model, and any operating CI/CD
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-deployment-pipeline-documentation-2" class="checklist-checkbox">
Deployment Rules that have been created
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-deployment-pipeline-documentation-3" class="checklist-checkbox">
Linked DevOps, GitHub, or other Deployment Pipelines
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-deployment-pipeline-documentation-4" class="checklist-checkbox">
How to deal with dataset schema changes during Development <a href="https://data-marc.com/2022/10/13/effect-of-dataset-changes-while-using-deployment-pipelines-in-power-bi/" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="deployment-pipeline-checklist-deployment-pipeline-documentation-5" class="checklist-checkbox">
How to revert to previous deployments, or "reverse" an accidental/mistake deployment <a href="https://data-marc.com/2022/10/13/effect-of-dataset-changes-while-using-deployment-pipelines-in-power-bi/" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<h2 id="footnotes">FOOTNOTES</h2>

[1] For example, approval of the deployment after peer-review, or objective test criteria.

[2] Apps are not handled by Deployment Pipelines; an App created in Development will not deploy to Test or Production. It may still be meaningful to use Development to create the app, and Test to test the app. The Test App can also be used for UAT.

[3] For example, that content is not deployed directly to Test or Production, content is not edited directly in the Workspaces, and XMLA external tools do not write to Test or Production datasets. The way of working is the most important thing to define; if this is not aligned among team members, the Deployment Pipeline will bring little value.

[4] A common use-case is when data content (Data Marts, Dataflows, Datasets) are in separate Workspaces & Pipelines than reporting content (Reports, Paginated Reports, Dashboards, Metrics). Linking these pipelines is done i.e. with Azure DevOps and the REST API.
