Hi,
I have table in my On premise SQL database, I have connected that to my Powerapps and the User Signed in can view all the data. But the Moment I create a RLS on my server side (which works as I have tested it in SSMS) the Powerapps becomes blank and the User does not see any of the records from the database.
I do not seem to find the where the issue could, this is my first time connecting to SQL database with RLS already implemented on the server side.
Please note: the user can see all the records when the RLS is not applied, but the moment it is applied Powerapps shows nothing to the user.
kindly help, what am I missing?
