Skip to main content

Core

New

Expand Power BI REST API / Fabric REST API to change the GIT branche of a workspace

Vote (1) Share
Martijn Kuiper's profile image

Martijn Kuiper on 22 Jul 2024 10:21:44

Power BI REST API


Using the Power BI REST API, it is possible to create a workspace and POST some settings, but there are some missing features.


The creation of workspaces is possible using a POST command to https://api.powerbi.com/v1.0/myorg/groups

The body has some options, but there is no option to set the GIT branche of a workspace

There is also no option to do this after creation using PATCH to the same endpoint.


Fabric

Since Fabric, all our content is being deployed to an abundance of workspaces. There is a need to create these through the API, since clicking every DTAP setup would require a lot of manual labour. This is time consuming and can lead to mistakes.


Manual labour

Underneath is a list of steps we go through before being able to properly use the DTAP workspaces and its Fabric Deployment Pipelines setup. Some of these steps are manual as long as the REST API is not expanded:


  • Create workspace, with a given name
  • Connect the workspace to the Fabric capacity
  • Add roles to the workspace with the proper rights
  • Manual: Change the description of the workspace
  • Manual: Change the domain to the correct domain
  • Manual: Setup the contact person / group
  • Manual: Connect the workspace to the Azure Log Analytics
  • Manual: Connect the workspace to a GIT branche
  • Create a deployment pipeline, with a given name and description
  • Assign three workspaces to the three stages
  • Add a usergroup as an Admin to the deployment pipeline
  • Manual: Change the three default stagenames to our internal names


In bold the step for this idea