Add service principal to Fabric workspace using Power BI REST API
Image Source:
Power BI
Sep 20, 2023 3:00 PM

Add service principal to Fabric workspace using Power BI REST API

by HubSite 365 about Marc Lelijveld (Data – Marc) [MVP]

Data Platform MVP | FastTrack Recognized Solution Architect | Microsoft Certified Trainer | Public Speaker | Data enthusiast | Solution Architect Data & Analytics

Data AnalyticsPower BILearning Selection

Lately, I found myself struggling using the Power BI REST API to add a service principal to the (Fabric) workspace. After I engaged with some other folks, I man

Add service principal to Fabric workspace using Power BI REST API has been a recent challenge. The API was used to add a service principal to a workspace and automate tasks. This might be less beneficial for some, but it is crucial for documenting the process. This automation can help when you want to manage all workspaces as a Fabric administrator, without having direct access to them. Issues were faced identifying the service principal in Azure Active Directory.

Before finding a solution, other people were engaged for help. It was found that the identifier needed in the API body wasn't the Object Id listed in the application registration in Azure Portal. Instead, the required Id was found in the related Enterprise Application. This will assist in automating steps where a service principal identifier is required. To execute these API's, PowerShell was used.

  • Fabric Workspace
  • Power BI REST API
  • Azure Active Directory
  • Fabric Administrator
  • Service Principal
  • Enterprise Application

A Deeper Look into the Main Topic

The main topic revolves around using the Power BI REST API to add service principals to a Fabric workspace. These principals are intended to automate various tasks within the workspace, such as analyzing best practices, reading metadata, and other kinds of automation. The challenge arises when trying to identify the service principal in Azure Active Directory.

Notably, efforts made to finding the solution have involved the community, implying a collaborative approach towards problem-solving. The author has also provided code snippets to aid others in similar situations, demonstrating a commitment to knowledge sharing within the community. Overall, this discussions provides intricate insights into using APIs to manage Fabric workspaces and deal with automation challenges that may arise.

  • Automation of tasks in Fabric Workspace
  • Challenges in identifying the Service Principal
  • The role of the community in problem-solving
  • The author's commitment to sharing knowledge
  • Managing Fabric workspaces with APIs


Read the full article Add service principal to Fabric workspace using Power BI REST API

Learn about Add service principal to Fabric workspace using Power BI REST API


The main topic of the text concerns the author's experiences and methods of adding a service principal to a Fabric workspace using the Power BI REST API. The author found the task challenging to navigate at first, but eventually managed to succeed after much engagement and learning. The blog post details the author's mistakes and solutions found during the process and is intended as a personal reminder of the strategies used. The author also discusses automated tasks in Fabric and offers reasons for wanting to add service principles to a workspace. The author emphasizes the desire to avoid user-specific accounts during automated tasks, stressing a preference for service principals.

More links on about Add service principal to Fabric workspace using Power BI REST API

Solved: Re: How to add a service principal profile to a wo...
Sep 2, 2023 — Hi I was able to write code which create a service principal profile and publish a PBIX file into a workspace all using the PBI REST API. Exactly.
Automate Power BI Premium workspace and dataset tasks ...
Nov 21, 2022 — Enable service principals · Go to the Power BI Admin portal and then select Tenant settings. · Scroll to Developer settings and then expand Allow ...
Embed Power BI content with service principal and an ...
Sep 4, 2023 — Learn how to authenticate for embedded analytics by using an Azure Active Directory application service principal and an application secret.
Use Power BI API with service principal (Preview)
We're thrilled to announce that you can authenticate to Power BI with service principal (also known as app-only authentication), available by end of week in ...
Connect with Power BI to the Power BI REST API with a ...
Mar 25, 2023 — Make sure to add the Service Principal to each workspace you wish to see. That's already it! This way, you can call all “GET” REST APIs from ...
Authentication not granted for service principal token in MS ...
Jul 29, 2023 — I am trying to connect to OneLake API in Microsoft Fabric using Python in VScode. So far I have. Registered an app in Azure with these API ...
Home · Power BI Dev Camp
The Power BI Service has introduced a new feature known as service principal profiles which adds a powerful new dimension for scaling multi-tenant applications ...
Session 20: Scaling Multi-tenant Solutions using Service ...
Developer sample demonstrating how to use service principal profiles to manage a multi-tenant environment with Power BI and App-Owns-Data embedding.


microsoft expert advice on Power BI REST API, adding service principal to Fabric workspace, microsoft Fabric workspace automation, Power BI dataset automation using Fabric, managing workspaces using Microsoft API