Hi @dli9 ,
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 username@contoso.com.
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://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-the-username-or-userprincipa...
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.
