Girish Uppal Power BI Workspace Identity

What is Workspace Identity?

What is a Workspace Identity?

Workspace Identity is an automatically managed service principal associated with a Microsoft Fabric or Power BI workspace. 

It provides the workspace with its own identity in Microsoft Entra ID, allowing workspace resources to authenticate securely with external services

What gets provisioned?

When a Workspace Identity is created:

  • Microsoft Fabric automatically creates a service principal in Microsoft Entra ID.
  • An associated application registration is also created.
  • Credential management is handled by Microsoft. Also, there is no need to maintain passwords, secrets, certificates by Fabric administrators or Global administrators
 

Bit of History

For many organisations, the journey with Microsoft Fabric and Power BI is evolving beyond analytics and visualisation.
As environments grow in scale and complexity, ensuring secure, governed, and automated access to data has become a top priority. This is where Workspace Identity comes in.
 
By providing a dedicated identity for Power BI and Microsoft Fabric workspaces, it enables secure access to data sources without requiring personal credentials, stored passwords, or service accounts, helping organisations strengthen both security and operational efficiency.
 

Traditionally, Power BI solutions often relied on:

  • Personal user accounts
  • Shared service accounts
  • Service principals with client secrets
  • Stored database credentials

How it works?

  1. A workspace administrator creates a Workspace Identity.
  2. Microsoft Fabric provisions and manages the identity in Microsoft Entra ID.
  3. Access permissions are granted directly to the Workspace Identity on target resources.
  4. Fabric obtains authentication tokens on behalf of the workspace when accessing those resources
 

Where it can be used?

 

Semantic Models
Semantic models can authenticate to supported data sources using the workspace identity rather than a user’s credentials
 
Data Pipelines
Fabric Data Pipelines can access and move data securely without storing passwords 
 
One Lake shortcuts
Workspace Identity enables secure connections to Azure Data Lake Storage Gen2, including storage accounts protected by network restrictions
 
Dataflows Gen2
Dataflows can use the workspace identity for secure ingestion and transformation processes 
 
SharePoint Integration
Workspace Identity can authenticate directly against SharePoint using least-privilege permission models eliminating the need for personal accounts during dataset refreshes 
 
As an example – when you connect to Azure Data Lake Storage Gen2 as a data source while creating Data Pipeline, you get an option to select Authentication kind as “Workspace Identity”
 
 
 

Where to create Workspace Identity?

Workspace Identity must be created in Power BI or Fabric workspace
 
 
 

What gets created in Azure?

 
App registration is created as shown below
Fabric Identity Management is added as an owner for the App registration
Under Administrative Roles, Cloud Application Administrator role gets assigned.