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
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?
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
Ready for more? Take a weighted mock or try free practice questions.