Forum Discussion
row level & view level security not working through live connection to SQL server
Hi Nisarg,
In this scenario, it's time to use RLS to control the data access. Usually, a few people will connect to the SQL Server to create reports, while many more people only read the report. So it isn't a good practice that everyone connects to the DB with an account. Power BI provides the function RLS (Row level security). People only see the data filtered by the RLS. Please reference powerbi-admin-rls for more details. One important tip: RLS roles can be only created in the Desktop and then be assigned to users in the Service.
If users create their own report, they will connect to SQL DB with their own account, perhaps there won't be a problem.
Best Regards!
Dale
Thank you. I think RLS is not helping me here. I am looking for dynamic security. I have a separate table for security. I would like to leverage on that and use it in view while retrieving records. The problem is - with live connection to SQL server, it always passes credential of someone who has published the report. From desktop it is working fine, from service, this is an issue. I logged the bug with PBI team, not sure when they are going to fix it
