One Lake Security - Row Security not available

[MorenaBI]

Hello, I try to configure row level security with OneLake security feature. After creating a role, I can't see the option "Row Security" when I click the 3 dots on a specific table within a role. I read the following link, but I also can't find where to switch the SQL Analytics Endpoint on the lakehouse to "User's identity" mode through the Security tab. I have F2 license and Trial.

https://learn.microsoft.com/en-us/fabric/onelake/security/row-level-security

[siennafaleiro · Accepted solution]

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.

[v-saisrao-msft]

Hi @MorenaBI,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

Hi @MorenaBI,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

[v-saisrao-msft]

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.

[MorenaBI]

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?

[v-saisrao-msft]

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.