Individual skill
fabric-lakehouse-access-control
Troubleshoot Microsoft Fabric Lakehouse access control issues including OneLake security roles, SQL analytics endpoint permissions, workspace roles, data access roles, row-level security (RLS), column-level security (CLS), object-level security (OLS), dynamic data masking, shortcut permissions, Direct Lake security integration, DefaultReader role, ReadAll permission, and OneLake data access role conflicts. Use when users report permission denied, unauthorized access, missing data, empty query results, or cannot see tables in Fabric Lakehouse.
skills/fabric-lakehouse-access-control/SKILL.md
Source commit cee03dc1199cd2a9765b439fa41930d480e5989d
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- Yes
- Observed behavior
- Not checked yet
- Last checked
- Nov 6, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 17
- Repository last updated
- Jun 7, 2026
- License
- MIT
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- claude Repository topic
- claude-skills Repository topic
- copilot Repository topic
- copilot-skills Repository topic
- fabric Repository topic
- microsoft-fabric Repository topic
- data Derived category
- security Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
LICENSE.txtdoc · 11,358 bytesSKILL.mdcore · 7,715 bytesreferences/direct-lake-security-reference.mddoc · 5,631 bytesreferences/onelake-security-reference.mddoc · 7,493 bytesreferences/sql-endpoint-security-reference.mddoc · 6,809 bytesreferences/workflow-diagnostics.mddoc · 10,586 bytesscripts/Audit-SqlEndpointPermissions.ps1runs · 7,011 bytesscripts/Test-LakehouseAccessControl.ps1runs · 9,999 bytestemplates/Validate-RowLevelSecurity.sqlasset · 5,949 bytes
Read excerpt
# Microsoft Fabric Lakehouse Access Control remediate
Diagnose and resolve access control issues across all security layers of Microsoft Fabric Lakehouse, including workspace roles, item permissions, OneLake security data access roles, SQL analytics endpoint granular permissions, and Direct Lake semantic model security integration.
## When to Use This Skill
- User cannot access lakehouse data or sees "permission denied" errors
- Queries return empty results or missing rows/columns unexpectedly
- OneLake security roles not applying or taking too long to propagate
- SQL analytics endpoint permissions not restricting access as expected
- Direct Lake semantic model returns errors after enabling OneLake security
- Shortcut data is inaccessible or returns 404 errors
- DefaultReader role conflicts with custom data access roles
- Deployment pipeline or git integration issues with data access roles