Skip to content

Granting and restricting access at the workspace level

Microsoft Fabric workspaces use role-based access control to manage who can view, edit, or administer items within a workspace, separate from item-level sharing permissions. Understanding the four built-in workspace roles and how they interact with Microsoft Entra ID (formerly Azure AD) security groups is essential for implementing least-privilege access in an analytics solution.

1 · Learn the must-know

  • Fabric workspaces support four built-in roles: Admin, Member, Contributor, and Viewer, each granting progressively fewer permissions over workspace management and item operations.
  • Admins can manage workspace access, delete the workspace, and change workspace settings (including OneLake data access rules and Git integration); Members can additionally manage access for Contributor and Viewer roles but not Admins.
  • Contributors can create, edit, and delete items within the workspace but cannot manage workspace-level access or settings, while Viewers have read-only access to workspace content.
  • Roles can be assigned to individual users, Microsoft Entra security groups, distribution lists, or Microsoft 365 groups, and using security groups is the recommended practice for scalable governance.
  • Workspace roles grant access to all items in the workspace by default, but item-level sharing can grant more granular permissions (e.g., Read or ReadWrite) to specific reports, semantic models, or lakehouses without granting full workspace access.
  • Workspace access control is separate from OneLake data access roles, which allow more granular, folder-level security within a lakehouse independent of the broader workspace role assignments.

2 · Check your understanding

Check this objectiveFree · always available

A Fabric workspace contains a lakehouse and several published Power BI reports. The data engineering lead wants business analysts to browse and run the existing reports and query the lakehouse SQL analytics endpoint for read-only analysis, but must prevent the analysts from creating, editing, or deleting any item in the workspace. Which workspace role should be assigned to the analysts?

Your objective map0 tried · 0 answered correctly · 54 untouched

What you have tried across DP-700's objectives, not a readiness score.

Implement and manage an analytics solution30-35% of the exam0 of 18 tried
Ingest and transform data30-35% of the exam0 of 19 tried
Monitor and optimize an analytics solution30-35% of the exam0 of 17 tried

3 · Keep going