How to Understand Microsoft Fabric Admin Roles

Microsoft Fabric Admin Roles : Microsoft Fabric is a new analytics platform that integrates various services and tools from Power BI, Azure Synapse, and Azure Data Factory into a single unified experience. It enables you to perform data engineering, data science, data warehousing, real-time analytics, and business intelligence tasks with ease and efficiency.

However, to manage and control Microsoft Fabric for your organization, you need to have the appropriate admin roles assigned to you. In this blog post, we will explain what are the different admin roles related to Microsoft Fabric, what are their responsibilities and permissions, and how to assign them to users.

How to Create a Deployment Rule for a Paginated Report with a Fabric Dataset

What are the Microsoft Fabric admin roles?

There are several admin roles that work together to administer Microsoft Fabric for your organization. Most of these roles are assigned in the Microsoft 365 admin portal or by using PowerShell. The capacity admin roles are assigned when the capacity is created.

The following table summarizes the main admin roles and their tasks:

Admin Role Description Tasks
Global administrator The highest level of access to all management features for the organization – Assign roles to other users <br> – Manage subscriptions and licenses <br> – Enable and disable Microsoft Fabric features <br> – Report on usage and performance <br> – Review and manage auditing <br> – Acquire and work with capacities <br> – Ensure quality of service <br> – Manage workspaces <br> – Publish visuals <br> – Verify codes used to embed Microsoft Fabric in other applications <br> – Troubleshoot data access and other issues
Power Platform administrator A role that has full access to all the Microsoft Fabric management tasks – Enable and disable Microsoft Fabric features <br> – Report on usage and performance <br> – Review and manage auditing <br> – Acquire and work with capacities <br> – Ensure quality of service <br> – Manage workspaces <br> – Publish visuals <br> – Verify codes used to embed Microsoft Fabric in other applications <br> – Troubleshoot data access and other issues
Fabric administrator A role that has full access to all the Microsoft Fabric management tasks – Enable and disable Microsoft Fabric features <br> – Report on usage and performance <br> – Review and manage auditing <br> – Acquire and work with capacities <br> – Ensure quality of service <br> – Manage workspaces <br> – Publish visuals <br> – Verify codes used to embed Microsoft Fabric in other applications <br> – Troubleshoot data access and other issues
Billing administrator A role that can manage subscriptions and purchase licenses – Manage subscriptions <br> – Purchase licenses
License administrator A role that can assign or remove licenses for users – Assign or remove licenses for users
User administrator A role that can create and manage users and groups – Create and manage users and groups <br> – Reset user passwords
Capacity administrator A role that can manage the capacity that they are assigned to – Assign workspaces to the capacity <br> – Manage user permission to the capacity <br> – Manage workloads to configure memory usage

How to assign Microsoft Fabric admin roles?

To assign Microsoft Fabric admin roles, you need to have either the global administrator or the user administrator role. You can assign the roles either in the Microsoft 365 admin portal or by using PowerShell.

Assign roles in the Microsoft 365 admin portal

To assign roles in the Microsoft 365 admin portal, follow these steps:

  1. In the Microsoft 365 admin portal, select Users > Active Users.
  2. Select the user that you want to assign the role to.
  3. Under Roles, select Manage roles.
  4. Expand Show all by category, then select the role that you want to assign. For example, Fabric administrator or Power Platform administrator.
  5. Select Save changes.

Assign roles by using PowerShell

You can also assign roles by using PowerShell. Users are managed in Azure Active Directory (Azure AD). If you don’t already have the Azure AD PowerShell module, download and install the latest version. Then follow these steps:

  1. Connect to Azure AD: Connect-AzureAD
  2. Get the ObjectId for the role that you want to assign. You can run Get-AzureADDirectoryRole to get the ObjectId. For example, for the Fabric administrator role: Get-AzureADDirectoryRole
  3. Get the ObjectId for the user that you want to assign the role to. You can run Get-AzureADUser to get the ObjectId. For example, for a user named John Smith: Get-AzureADUser
  4. Add the user to the role by using Add-AzureADDirectoryRoleMember. For example: Add-AzureADDirectoryRoleMember

What Licenses are Needed to Work with Lifecycle Management in Microsoft Fabric

FAQs

Here are some frequently asked questions about Microsoft Fabric admin roles:

  • Q: What are the prerequisites for using Microsoft Fabric?
  • A: You need to have a Power BI Premium license or an Azure Synapse Analytics license to use Microsoft Fabric.
  • Q: How much does Microsoft Fabric cost?
  • A: Microsoft Fabric is included in your Power BI Premium or Azure Synapse Analytics license. There is no additional cost for using it.
  • Q: How can I learn more about Microsoft Fabric?
  • A: You can check out the following resources for more information about Microsoft Fabric: