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 secu...
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-Major-limitations/m-p/4650566/highlight/true#M14569
