Need to secure a table - thoughts on how?

Hello Bshin 

OneLake Data Access Roles provide folder-level access control within your lakehouse:

1. Create a custom role for your sensitive data

2. Assign this role to the specific folder containing your sensitive table

3. Add only your 3-4 privileged users to this role

4. Ensure these users aren't also assigned to the DefaultReader role (which grants access to all folders)

https://data-mozart.com/understanding-data-access-options-in-microsoft-fabric/

• Be aware that implementing RLS, OLS, or CLS on the SQL analytics endpoint will cause Power BI queries in Direct Lake mode to fall back to Direct Query mode

• Users with write access (Admin, Member, Contributor roles) aren't restricted by OneLake data access roles - they retain full access to data in OneLake

• For complete isolation, consider creating a separate workspace for this sensitive data, as OneLake data access roles currently only apply to users accessing OneLake directly