Deploy Reports from Development to Test to Production using the Power BI Deployment Pipelines

By:   |   Comments (1)   |   Related: > Power BI


How can the new Power BI Deployment Pipeline help with deploying dashboards and reports from Development to Test to Production?


A recently introduced feature in Power BI has upended the deployment and release process for Power BI files. The new process, called the Power BI Deployment Pipeline, provides a clear path for moving a report and its related data source from Development to Test to Production.

The process does not replace any local source control methods that you are using for your PBIX files (you are using some source control process, correct? One Drive or SharePoint could potentially be excellent options for retaining prior versions). By using the Deployment Pipeline, you can easily manage the prototyping and testing process that needs to be in place for your Power BI workspaces within the Power BI service.

Of course, with any new feature in Power BI, and especially ones that are still in preview mode (this feature is still in preview mode as of this tip’s initial publication) several caveats and restrictions exist. First, and foremost, you must have Premium capacity permissions and the workspace must live within the Premium capacity to utilize the Deployment pipeline. Next, the deploying user must have permissions to create workspaces to move reports and data sets through the deployment pipeline and the deploying user must also be an admin for the workspace to be deployed; likewise, the workspace must be using the new workspace "experience". Finally, a workspace can only live on a single pipeline at a time.

As all the work for this particular feature occurs on the Power BI Service; thus, we will not be working with Power BI Desktop. However, if you need the latest version of Power BI Desktop (PBID), you can download the latest version of Power BI desktop.

To get started using Deployment Pipelines, you simply navigate to the Power BI home page for your organization and click on Deployment pipelines link on the left side menu. To create the Deployment pipeline, you would click the Create a pipeline button.

create a deployment pipeline

Next, you specify the pipeline name and add a description.

create pipeline window

Now with the Deployment pipeline created, we have to assign an existing workspace to our deployment pipeline.

assign workspace for pipeline

At this point in the process, we first select the workspace that will be assigned to the pipeline. Remember only workspaces in a premium capacity will be available to assign; additionally, the workspace must be using the new workspace experience. Finally, the assignment requires setting the stage to assign to the workspace, Development, Test, or Production and clicking Assign. Even if a workspace is assigned incorrectly, we can move the deployment backwards or delete it completely form the pipeline (we will cover those options later in this tip).

Assign a workspace to a pipeline.

In the below illustrations, the workspace was assigned to the Development stage. The workspace contained two reports and two datasets. The workspace is assigned as a whole package with all reports and datasets. Notice the Deployment button in the bottom, right corner of the window. The deployment button would push the workspace from Development to test. In the below examples, all items are moved from Development to Test.

Assign to Development

As an alternative, the deployment can be limited to just a select number of reports, date sets, and dashboards; for example, just one report and its related dataset. You may also notice the refresh options in the above and below illustrations. When a workspace is assigned / deployed, it may require the dataset to be refreshed to get the most current data. Such instances often would occur if the structure and the related data sets were changed in the original Power BI file. You must deploy related items together, so for instance, a report cannot be deployed to the next stage without its related data set.

Select items to deployment.

In addition to the deployment option, clicking on the ellipse in the upper right corner of the Development stage box, allows the developer to:

  • Navigate to the root app
  • Unassign the workspace (remove from the pipeline)
  • Update the app
  • Set workspace access permissions and settings.
Development Options

If the Unassign workspace option is selected, it removes all the related workspace deployment settings.

Unassign workspace.

As an alternative to unassigning the workspace, the entire pipeline can be deleted by clicking on the ellipse / three dot button in the upper right corner of the Power BI window. Once deleted, though, the pipeline details are removed completely, similar to unassigning a workspace.

delete pipeline

Clicking on the Settings gear button allows the developer to change the pipeline name or descriptions, as noted below.

pipeline settings.

If a workspace is in the Test or Production state of the pipeline, one additional option is available; this option, "Deploy to previous stage", provides the ability to move the workspace back one step in the pipeline staging process.

deploy to previous stage

Certainly, once in production, the workspace can be used to update the App related to the workspace.

When running through the pipeline process, one of the main errors that will surface is related to permissions, specifically the permission to create workspaces. This particular issue is shown in the below illustration.

workspace permissions errors.

It should also be noted that deployment pipeline permissions are not the same as workspace permissions nor App permissions. A pipeline admin can grant permissions to another user via the Access button in the upper right corner of the Power BI window.

pipeline access

One final option to consider within deployment pipelines is the ability set rules around the data set refresh process. Data set rules are established by clicking on the lightning button in the upper right corner of the deployment stage. In order to take advantage of data set rules, parameters for items such as the database source must set via a parameter in the root file.

Data set rules.

After clicking on the lightning button, the related data set must be selected.

Deployment Settings for Datasets

After selecting the data set, you can select the Rule option, and then click on Add rule button. These tips from Koen Verbeeck could be helpful in understanding setting up data sources in Power BI: Power BI Desktop Data Source Considerations and Power BI Datasets. Power BI offers the option to set database rules either via parameters rule or data source rules.

New rule.

Finally, we can tell the pipeline stage to utilize a new connection string for the server and database details. These situations would be especially helpful when you have Development, Test, and Production databases that need to be used in each of the respective stages of deployment. Thus, in the below example, we are switching the data source to our localhost and the WideWorldImportsDW database.

New Rule details

In this tip we summarized the new deployment pipeline feature within the Power BI service. The deployment pipeline provides a rich way to move a report or dashboard prototype through the stages of the report development.

Next Steps

Learn more about Power BI in this 3 hour training course.

Click here to start the Power BI course

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Thursday, January 14, 2021 - 11:32:28 PM - Jc ls Back To Top (88044)
can someone help me on this, please? I have 3 azure analisys services databases dev, qa, and prod however when i change the conection in the test environment pointing the the QA DB it doesn´t work

get free sql tips
agree to terms