Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Econroy

OneLake Security RLS | Join tables and Call Username function

Submitted by Tuesday

Our team would like join to our security mapping table in the rule and call the employee that is querying's username and filter by it. It would look like:

select * from my_table
inner join security_table
on security_table.projectID = my_table.projectID
where security_table.username = username()

This would allow us to dynamically set our RLS on the table.

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
watermelonjam
Regular Visitor
Thursday
Not possible. RLS rule SQL syntax doesn't support joins. See https://learn.microsoft.com/en-us/fabric/onelake/security/row-level-security#syntax-rules Functions such as USERPRINCIPALNAME() are also not valid. See https://community.fabric.microsoft.com/t5/Fabric-platform/Row-Level-Security-in-OneLake-preview-Majo...
Econroy
Regular Visitor
Thursday
Hey watermelonjam - thanks for sharing the link. It's nice to see why USERNAMEPRINCIPALNAME() function is not currently available in OneLake Security. Good to know moving forward, MS is working on a solution to implement this in the future. Will keep my eyes out for any GA announcement regarding the implementation.