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:
- In the Microsoft 365 admin portal, select Users > Active Users.
- Select the user that you want to assign the role to.
- Under Roles, select Manage roles.
- Expand Show all by category, then select the role that you want to assign. For example, Fabric administrator or Power Platform administrator.
- 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:
- Connect to Azure AD:
Connect-AzureAD
- 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
- 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
- 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: