Forum Discussion

MorenaBI's avatar
MorenaBI
Helper I
1 year ago
Solved

One Lake Security - Row Security not available

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

data engineering
  • siennafaleiro's avatar
    siennafaleiro
    1 year ago

    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.

8 Replies

    • nguyenhieubis's avatar
      nguyenhieubis
      Frequent Visitor
      11 months ago

      The same issue. I can't see the security tab anywhere, even through my capacity is F64.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    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.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    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's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    Hi MorenaBI,

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

     

    Thank you.

  • siennafaleiro's avatar
    siennafaleiro
    New Member
    1 year ago

    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.