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

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