PowerBI CICD with Azure DevOps (Creation of the release pipeline) (3/3)

September 14, 2022

Business Inteligence

Read in minutes

Previous post Setting up the tenant

For this part, we assume that you already have a pipeline for power BI. Moreover, the solution presented here fit our project, it may be that you need to add or modify some steps.

Deployment in DEV

Firstly, we need to add the Power BI Action task.

  1. Click on the + sign
  2. Search for Power BI Actions
  3. Add the task
Figure 8 Add a task
  1. Add the service connection
  2. Select the action Upload Power BI Report
  3. Add the name of the workspace
  4. Give the path of the folder where your reports are stored. Be careful, your report name can not contain a dot.
  5. Check Overwrite Power BI File
Figure 9 Power BI Action: Publish

Deployment in UAT

For deploying reports in UAT we use the same system, but we must add more steps because reports are published with the DEV dataset. We must therefore change it to the associated dataset.

The first task is another Power BI Action: Publish   the configuration is identical as the one for DEV, we just change the Workspace name to UAT.

The second task give the ownership of all datasets to the service connection.

  1. Selection the task Take dataset ownership
  2. Add the name of the workspace
  3. Check Update all datasets in workspace the dataset name will be ignored
Figure 10 Power BI Action: Take ownership

Then, we need to update the gateway.

  1. Selection the task Update gateway
  2. Add the name of the workspace
  3. Fill in the name of your dataset and of the getaway. We cannot check the Update all  option because the metrics report will make the job fail
Figure 11 Power BI Action: UpdateGateway

Then, we need to update the datasource.

  1. Selection the task Update datasource connection
  2. Fill in the name of the dataset
  3. Choose the Datasource type
  4. Fill the information with the one that’s fit your project
Then, we need to update the datasource.

Figure 13 Power BI Action: UpdateDatasource

The last two task must be replicate for all you report since we can’t use the Update all option.

Deployment in PROD

This part is the same as the UAT one, we just needed to change the name of the workspace and the name of the new database everywhere they appear in different steps.

Report development

Now, when you develop a report make sure to push it to your repository with the Data source settings setup with the DEV data source


Related articles

March 25, 2024

Read in minutes

Getting started with the new Power BI Visual Calculations feature!

Power BI’s latest feature release, Visual Calculations, represents a paradigm shift in how users interact with data.      Rolled ...

February 20, 2024

Read in 5 minutes

Revolutionizing Data Engineering: The Power of Databricks’ Delta Live Tables and Unity Catalog

Databricks has emerged as a pivotal platform in the data engineering landscape, offering a comprehensive suite of tools designed to tackle the complexities of d...

November 20, 2023

Read in 5 minutes

AKABI’s Consultants Share Insights from Dataminds Connect 2023

Dataminds Connect 2023, a two-day event taking place in the charming city of Mechelen, Belgium, has proven to be a cornerstone in the world of IT and Microsoft ...