implementing dynamic row level security

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