Roles in workspaces
Workspace roles let you manage who can do what in a Microsoft Fabric workspace. Microsoft Fabric workspaces sit on top of OneLake and divide the data lake into separate containers that can be secured independently. Workspace roles in Microsoft Fabric extend the Power BI workspace roles by associating new Microsoft Fabric capabilities such as data integration and data exploration with existing workspace roles. For more information on Power BI roles, see Roles in workspaces in Power BI.
You can either assign roles to individuals or to security groups, Microsoft 365 groups, and distribution lists. To grant access to a workspace, assign those user groups or individuals to one of the workspace roles: Admin, Member, Contributor, or Viewer. Here's how to give users access to workspaces.
To create a new workspace, see Create a workspace.
Everyone in a user group gets the role that you've assigned. If someone is in several user groups, they get the highest level of permission that's provided by the roles that they're assigned. If you nest user groups and assign a role to a group, all the contained users have permissions.
Users in workspace roles have the following Microsoft Fabric capabilities, in addition to the existing Power BI capabilities associated with these roles.
Microsoft Fabric workspace roles
| Capability | Admin | Member | Contributor | Viewer |
|---|---|---|---|---|
| View and read content of data pipelines, notebooks, Spark job definitions, ML models and experiments, and Event streams. | ||||
| View and read content of KQL databases, KQL query-sets, and real-time dashboards. | ||||
| Connect to SQL endpoints of Lakehouse and Data warehouse. | ||||
| Read Lakehouse and Data warehouse data and shortcuts1 through SQL endpoints. | -2 | |||
| Read Lakehouse and Data warehouse data and shortcuts1 through OneLake APIs and Spark. | - | |||
| Read Lakehouse data through Lakehouse explorer. | - | |||
| Write or delete data pipelines, notebooks, Spark job definitions, ML models and experiments, and Event streams. | - | |||
| Write or delete KQL query-sets, real-time dashboards, and schema and data of KQL databases, Lakehouses, data warehouses, and shortcuts. | - | |||
| Execute or cancel execution of notebooks, Spark job definitions, ML models and experiments. | - | |||
| Execute or cancel execution of data pipelines. | ||||
| View execution output of data pipelines, notebooks, ML models and experiments. |
1 Additional permissions are needed to read data from shortcut destination. Learn more about shortcut security model.
2 Admins, Members, and Contributors can grant viewers granular SQL permissions to read Lakehouse and Data warehouse data through SQL endpoints.