Forum Discussion
One Lake Security - Row Security not available
You don't see the “Row security” option and can't switch the SQL Analytics Endpoint to “User’s identity” mode because your workspace is running on F2 (free) capacity, which does not support those features. You need to upgrade to at least F64 capacity or P1 Premium, which are required to enable both the Row-Level Security UI and the user's identity mode for the SQL Analytics endpoint.
Hi MorenaBI,
It appears the issue is related to capacity limitations. With an F2 (free) capacity, features such as 'Row Security' and 'User's identity' mode are not available. Upgrading your workspace to F64 capacity or higher, or to a P1 Premium capacity, should enable these features.
Thank you.
Thank you for your feedback. Can I create RLS on a lakehouse object in a different way? Does SQL security work the same as on warehouse objects?
Hi MorenaBI,
Yes, SQL-based row-level security is supported on Fabric Warehouses. You can use standard T-SQL syntax, including CREATE SECURITY POLICY and predicate functions, just as you would in Azure SQL or Synapse.
Row-Level Security in Fabric Data Warehousing - Microsoft Fabric | Microsoft Learn
Thank you.