Forum Discussion
different rls in different page
I'd like to grant access to users in a report for them to see all data in specific pages and in other pages to see only data related to their username.
for example a person can see all customer data in specific pages and in other pages he can see only his customer's data.
I have created page level rls and username rls but when i share the report the user always see all pages filtered by his customers
Hi, Anonymous ;
If you publish your Power BI Desktop report to an app workspace within the Power BI service, the roles will be applied to read-only members. You will need to indicate that members can only view Power BI content within the app workspace settings.
You can make this change by logging in to app.powerbi.com (as a group admin), and using the left nav to choose the App Workspace (group) and then Edit Workspace.
This is described in the document:
Row-level security (RLS) with Power BI
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous , You need to have a table with the customer and email (the login email), That should join with your customer dimension.
On that table create a role
email= userprincipalname()
RLS for page navigation https://www.youtube.com/watch?v=FrEDZZXiit8
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
If you publish your Power BI Desktop report to an app workspace within the Power BI service, the roles will be applied to read-only members. You will need to indicate that members can only view Power BI content within the app workspace settings.
You can make this change by logging in to app.powerbi.com (as a group admin), and using the left nav to choose the App Workspace (group) and then Edit Workspace.
This is described in the document:
Row-level security (RLS) with Power BI
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
