implementing dynamic row level security

[Anonymous]

Want to create a table with 200 employees to display the salary of employee and each employee can see their salary only not others using dynamic row level security 

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created some data:

Salary：

Email:

Here are the steps you can follow：

Create a Role in Power BI Desktop and use the USERPRINCIPALNAME() function to achieve dynamic row-level security

Model – Manage roles – Create Role – Select the table with Email – Create Dax expression

Publish it to Power BI Service, select the data set of this report, and click Security.

Enter the Row-Level Security interface and add everyone's email (you can also create a group and add everyone to this group, which is more convenient for management)

After setting it up, you can share its report with others, and everyone can only see the information they specify.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards

Note here:

The user you share the report with must be in the role of View in the workspace, otherwise RLS will fail.

This is a link about RLS content:https://addendanalytics.com/dynamic-rls-in-power-bi/

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

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

[amitchandak]

@Anonymous , You need secure salary table, it should be with a table(or it should have), has email , that is filtered using RLS

refer how to use

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

refer: https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies