RLS using EntraId groups on Warehouse

Hi  v-sdhruv 

I've been trying to implement RLS using Entra ID groups on my Lakehouse table in SQL endpoint, but I'm running into issues.

Here's what I tried:

CREATE FUNCTION Security.fnRLSGroupFilter(@UserPrincipalName AS VARCHAR(100))

RETURNS TABLE

WITH SCHEMABINDING

AS

RETURN

    SELECT 1 AS AccessGranted

    WHERE IS_MEMBER('ReaderFabricDemoGroup') = 1;

GO

I have also tried using @UserName

However, the policy doesn't seem to work as expected. 

Can you share some sample scripts or working examples of RLS using Entra ID groups in Fabric lakehouse SQL Endpoint or Warehouse tables? It would be super helpful to see how others have approached this.

Thanks!