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

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

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

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

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