Share
ReportHello All - I am facing a vexing problem which I seek help on. Essentially, the server side RLS does not seem to work with PowerApps. I have a table in Azure SQL PaaS and 3 AD groups (say AD1, AD2 and AD3) - each AD group has a distinct set of users. The AD groups have been added to the database as users (using CREATE USER [AD1 etc] AS EXTERNAL USER) - I am using SSMS to access and test the database. The same groups have been added to PowerApps to grant access to an app. I have added the required Filter predicate and Security Policy for a server side RLS. Using SSMS and logging in as different users into SSMS, I can confirm that the RLS is correctly and consistently filtering rows as desired.
Now the problem
When I go PowerApps, it shows all the rows for all the user groups (essentially it is not filtering the relevant rows for AD1, AD2 and AD3). I am genuinely puzzled at the error - if anything, it should show zero rows - however, it is showing all the rows without any filtering and hence does not respect the filter predicate.
Please help me why a server side RLS does not seem to work in PowerApps.
All responses (
Answers (
356
