Forum Discussion
Helper IIIRLS for giving the access
Hi all,
I have a quick question, please. I will have to give access to almost 10 users and restrict the rest. However, earlier on i had restricted everyone through the report level filter and had hidden that on pbi desktop, so that no user will be able to use it in PBI service. So, is this possible to do it other way around through RLS? I mean if i have got a list of users, can i give them the access through any RLS method and the rest of people should automatically be restricted from these options on PBI service through the report level filter used, which i have also hidden on PBI desktop or will the RLS just work for all the ones who need to be restricted from seeing and filtering through a few options?
Hope i am explaining it properly.
Thanks
2 Replies
- amitchandak
Super User
samoberoi , Filter region can not be hidden selectively as of now. Any reason , you are not using Row level security of Power BI
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
Power BI- Row Level Security(RLS): Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc
Thank amitchandak for your prompt reply.
Hi samoberoi ,
Based on the information you provided, you can use RLS to grant access to specific users and restrict access to others. You can follow the steps below:
- Define roles in Power BI Desktop. Each role can have DAX filter expressions that determine what data the role can access. For your scenario, you can create a role that contains specific users to whom you want to grant access. See the official documentation for more information:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn - After publishing the report to the Power BI service, you can assign users to the created roles. This step is critical because it maps the actual users to the roles defined in Power BI Desktop and their corresponding access levels. Keep in mind that RLS applies to users with viewer permissions in the workspace. See this guide for detailed steps:
Workspaces in Power BI - Power BI | Microsoft Learn - Test the RLS settings to ensure they are working as expected. This helps verify that the access restrictions are applied correctly. See the documentation here for more information:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Keep in mind that RLS filters a user's data at the row level based on the user's role. It does not restrict access to the report itself, but rather to the data in the report. If you need to restrict access to certain features in a report or Power BI service, consider using Workspace Access Control in conjunction with RLS.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Define roles in Power BI Desktop. Each role can have DAX filter expressions that determine what data the role can access. For your scenario, you can create a role that contains specific users to whom you want to grant access. See the official documentation for more information:
