Forum Discussion
How to restrict user access?
I'm showing my student's performance results on a tab. Is there a way to restrict each person from viewing the rest of their peers? If I'm Michael, I can only filter Michael and not see the rest. There are many students so creating different tabs or separate dashboards (then publishing) isn't viable.
I don't have pro/premium either, so i can't embedded the visuals to sharepoint or another site.
Hi Anonymous ,
If you want to realize that everyone can only see the data in their own rules, you can use RLS, in Power BI Desktop, by using the username() or userprincipalname() DAX function and configuring the correct relationship, you can assign it to the Power BI Service, and after the assignment is completed, share its report to others through sharing .
Notice:
1. The format of username() is DOMAIN\username, and userprincipalname() is used when the user is in the email format [email protected].
2. When you use RLS, the user's role in the workspace must be View, otherwise the RLS fails and the user sees all the data
3. Whether you or the user, you need the permission of Power BI Pro.
This is the related document, you can view this content:
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
https://www.edureka.co/blog/row-level-security-in-power-bi/
https://community.powerbi.com/t5/Community-Blog/Dynamic-Row-Level-Security-Dynamic-RLS/ba-p/787399
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous
If you don't have Pro or Premium license, how do you share the dashboard with students?
Please check these links:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://guyinacube.com/2020/02/25/can-you-use-groups-with-power-bi-row-level-security-rls/
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi Anonymous ,
If you want to realize that everyone can only see the data in their own rules, you can use RLS, in Power BI Desktop, by using the username() or userprincipalname() DAX function and configuring the correct relationship, you can assign it to the Power BI Service, and after the assignment is completed, share its report to others through sharing .
Notice:
1. The format of username() is DOMAIN\username, and userprincipalname() is used when the user is in the email format [email protected].
2. When you use RLS, the user's role in the workspace must be View, otherwise the RLS fails and the user sees all the data
3. Whether you or the user, you need the permission of Power BI Pro.
This is the related document, you can view this content:
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
https://www.edureka.co/blog/row-level-security-in-power-bi/
https://community.powerbi.com/t5/Community-Blog/Dynamic-Row-Level-Security-Dynamic-RLS/ba-p/787399
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
