Power BI is a data visualization software which is used to run reports and establish insights based on a company’s data. The deployment pipeline is an efficient and reusable tool that enables BI creators to manage the lifecycle of the organizational content. In my blog, I will elaborate the implementation of CI/CD pipelines using Azure DevOps which will permit you to deploy your local report to your Power BI service automatically.
You must meet certain conditions to access the deployment pipeline features. The conditions include-
1. You should have one of the following Premium licenses:
2. You should be an admin of a new workspace experience.
The three stages of Power BI deployment pipeline are –
1. Development: In this stage, you can design, build, and share Power BI reports and their content.
2. Test: In this stage, you can upload the modified report content so it can be moved to the test stage. You can follow these steps in the test environment:
3. Production: After testing the report content, you can use the production stage to share the final report content with the business users across the organization.
Follow these steps to get started with deployment pipelines-
1. Go to the navigation panel on the left side, then select ‘Deployment pipeline’ and click on’’ Create pipeline’.
2. A pop-up will appear. Enter the pipeline name and description (Optional)
3. Assign a workspace to the deployment pipeline. As you have now created a pipeline, you need to add Power BI report content to the pipeline, which can be done by assigning a workspace to the pipeline stage.
4. Select the workspace from the drop-down menu that you want to assign to the pipeline. Then select the stage you want to assign to the workspace.
5. In this stage, you can select items that you want to deploy to the next stage. Click on the ‘’Deploy’ button. The deployment process creates a duplicate workspace in the test or target stage.
Note-
6. The orange indicator means that the content between pipelines do not match and are not identical.
7. The following image shows how you have deployed your reports/dashboards from development to test and test to production environment.
8. Deployment Datasets Rules- Dataset rules allow you to configure the specific parameters and data sources in a dataset. While working on pipelines, you can have different stages that may have different configurations. Each stage can have different databases or different parameters. When you deploy report content between pipeline stages, dataset rules enable you to allow changes to the content, while keeping some settings intact.
-To create deployment dataset rules, select ‘Deployment settings’. Click on the ‘lightning bolt’ button.
9. A pop-up will open, then select the dataset you want to create a rule for.
10. Now expand the data source rules list, and then select ’Add rule’.
11. Now from the data source list, select a data source to be replaced.
*There are some dataset rules that need to be considered-
12. Pipeline Permissions- Select the right corner ellipsis to give workspace access to certain users. You can give the following permissions to the users –
Let us now look at the uses of Power BI deployment pipeline –
There you have it! I hope with the help of my blog, you will be able to get started with deployment pipelines in Power BI. If you’d like to continue your exploration on a related note, read our blog to know how you can import data in real-time by using Power BI Hybrid tables. Visit us at Nitor Infotech or reach out to us if you have any queries or suggestions related to this topic.
Subscribe to our fortnightly newsletter!