Forum Discussion
Post ProdigyRLS ( with a hundred users )
hi , i have around 100 users difined by Admin( Can see all the pages in the report ) , Area Sales Manager ( Can see only their region ) . My purpose is to define each users to see only what i set , so i will use RLS ,
but currently , i'm facing issue : i have to set up 1 by 1 of each email address , for 100 users , i think this is not a solution.
Do i have any calculation to get into relationship and then set it all in once ?
I have a table of :
*Name :
*Email :
*Defined level RLS : Admin or Area Sales Manager
how to set it all up it once ?
Another question : for those who are not in the list such as CEO , i only share her the access email , can she see all of the data instead using the table defined by RLS ?
thx
Hi Chanleakna123 ,
If you are a Office 365 global administration, you could create new groups in the Groups page of Microsoft 365 admin center and then add the users into it.
Here are some documents that you may need :
Add or remove members from Office 365 groups using the admin center
Create and manage distribution groups
Create, edit, or delete a security group in the Microsoft 365 admin center
For your second question, if you don't give her the workspace access or you just grant her a viewer, she will get error messages in all the visuals like the pic below.
When users can edit content in the workspace (the corresponding roles are admin, member and contributor), they will see all the data which is set RLS. For roles in the workspaces, you could reference the document : https://docs.microsoft.com/en-us/power-bi/service-new-workspaces#roles-in-the-new-workspaces
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
8 Replies
- Chanleakna123
hi Anonymous , hi how can i set up for users group ?
how to successfully do this ? right now i do it one by one email . i think this is not a solution.
thanks with Regards,
Leakna
