Hi @Davidu ,
Dynamic Row Level Security is very suitable for your demands. Here's a sample for your reference.
This is my test table:
Click on Modeling Tab and navigate to Manage Roles icon. Then define a role name and right-click on the required table. We are going to use USERPRINCIPALNAME() in the filter condition.
This function returns the name of the user as their email address.
Now we have completed the configuration in the desktop tool. We can test the roles in the desktop itself.
Under the Modeling tab, we have an icon called View as Roles. Click on that icon, we will get a new window.
We have to select both Other user and newly created Role. Then enter the email id of one user in the text box near to the Other user text.
User will only see the records related to himself.
If you share your reports on Power BI service, you should configure the RLS in app.powerbi.com.
For detailed steps, please refer the blog:Dynamic Row Level Security (Dynamic RLS) - Microsoft Power BI Community
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.