Forum Discussion
SQL Analytics Endpoint - RLS for Security Groups
Hi, I am trying to apply Row-Level Security on a Lakehouse SQL Endpoint. I have successfully applied RLS for individual users. However, I want to apply RLS for Entra ID Security Groups, as this is...
I had to use the Microsoft Graph API to populate a table with Security Groups and Members for applying RLS. Power Query couldn't save a dynamic source to a table, so I used Power Apps to create a table and then Power Query to pull that table into the Warehouse from Power Apps. It was a bit messy but gets the job done and runs quick. Unfortunately I've not seen anyway to implement Entra Security Groups directly.
Can you provide more details on how did you implement this.
