PowerBI CICD with Azure DevOps (Setting up the tenant) (2/3)

September 15, 2022

Business Inteligence

Read in minutes

Previous post Introduction & Implementation

Now, we need to enable the service to use PowerBI API

  1. Go to Settings
  2. Click to Admin portal
  3. Go for Tenant settings
  4. Then in the Developer settings part Allow service principal to use PowerBI API
Figure 5 Setting up tenant

Grant access to workspace

Now, we need to add the service as admin to the workspace

  1. Go to Workspace
  2. Click on the three dots and Workspace access
  3. Add the PowerBI service connection and give him Admin role
  4. Finally click on Add
Figure 6 Grant access to workspace

Adding the service as gateway owner

To be able to use the tenant create in the Azure Active Directory we need to add the service as owner of the gateway

Add the extension to Azure DevOps

As we explain before, this work is based on an extension. We need to add it to Azure DevOps.

  1. On the top right corner click on the and then Browse marketplace
  2. Search for PowerBI actions
  3. Click on Get it free
  4. Select your organization and download the extension

Creation of the service connection in Azure DevOps

To be able to use the tenant created in the Azure Active Directory we need to create a service connection in Azure DevOps

  1. Go for your organization settings and click on Service Connection
  2. Create a service connection by searching Power BI Service Connection
  3. Select Service Principal and then fill Tenant ID and Client ID with the credentials that you copied beforehand. If not, you can find it in the Azure Active Directory under the app registration menu
Figure 7 Add service connections

Now that we have set up every tool, we can create the release pipeline.


Related articles

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 ...

September 28, 2022

Read in minutes

Power BI and QlikView Comparison

When we talk about Business Intelligence and Data Visualization, there are 3 leaders on the market today; Power BI, Qlik (Qlikview & Qliksense) and Tableau....

September 14, 2022

Read in minutes

PowerBI CICD with Azure DevOps (Introduction & Implementation) (1/3)

Introduction The purpose of this document is to explain how to implement PowerBI CICD in Azure DevOps. This document is for those who are tired of publishing re...