Forum Discussion
Solved
RLS in Power BI report with Direct Query to Azure SQL Database
I have the below table in Az SQL database : Employee table EmployeeId, FullName, EmailId,"""""""""" And I am accessing the above table from the Az SQL database in the report via direct query. ...
Hi. It looks good, let me add something. Make sure the user is just viewer at the workspace, any other role will let them see everything even if they have RLS assigned. Otherwise, you can just share the report/app and don't even add user at the workspace. Make sure that there is no sharing or building permission enabled when sharing.
I hope that helps,
Hello Rohitb,
Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.