Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Requirement :
We have a table with the User, Customer and Sales value.
We need to show the total sales value for each customer. When user login to the report he wanted to see only his customer data.
Solution
We need to implement RLS.
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.
[User] = USERPRINCIPALNAME()
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.
Click OK and see the changes immediately.
Next step is to configure the RLS in app.powerbi.com
Go to the dataset tab and follow the below steps.
Click on 3 dots near to the dataset.
Click on security and you will be navigated to another page.
Here you can add all the users to the Member section. You can use either individual email id or group id.
Note: make sure your user does not have edit permission to this report. Otherwise, RLS will not work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.