Forum Discussion
Row Level Security not applying to some users
Hello community,
I am currently facing an issue with Power BI.
I have created some dashboards connected Analysis Services.
The dashboards are shared in SharePoint via the embed option.
I am using SSMS to manage the row-level security part.
I am facing some issues with my dashboards.
For users without Power BI license, the row-level security is working properly and filtering the user scope.
The dashboard is filtered using a DAX formula applied to some tables in SSMS.
When I share the dashboard to a user with a Power BI license, the filter applied is not working properly and the user can see all the data.
I need to be sure the dashboard is properly filtered for all the users as we are sharing very sensitive data.
If you have faced the same issue and find a solution, don't hesitate to tell me.
Thank you in advance,
Florian
ibarrau, we found the answer.
The RLS don't apply if you are added in Properties of the Analysis Services Server.
2 Replies
- ibarrauSuper User
Hi, be sure to check the roles of the people with licence at Power Bi Service Workspace. Only Viewers or users with no build permission (individual share) will apply RLS. Otherwise they will see all data because the have edit permission and you need to see all data to edit.
I hope that helps,