I am facing issue on Row level security

[prinuce]

Dear Power BI Champians, 

I need a help on RLS creation on power bi. Actually i have three table expenses, services and timesheet and each table connected each other. i have a create a RLS on 3 level. like divison wise. Example:- each Division have different manager each manager can see his all own division employee data and employee can see only own data based on login. I have shared the data please help me. 

its very urgent i will be always thankful for you. 

[TomMartens · Accepted solution]

Hey @prinuce ,

this article by Reza Rad explains how to implement Row Level Security that considers an organizational structure: Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-...

If this is not enough create a pbix that contains sample data (a screenshot is not enough), but still reflects your data model (three tables), upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx file as well.

Regards,

Tom

[TomMartens · Accepted solution]

Hey @prinuce ,

this article by Reza Rad explains how to implement Row Level Security that considers an organizational structure: Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-...

If this is not enough create a pbix that contains sample data (a screenshot is not enough), but still reflects your data model (three tables), upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx file as well.

Regards,

Tom

[prinuce]

Thank you @TomMartens i have created organization level hierarchy.

I have assign RLS for all user.

Dax is:- 

PATHCONTAINS(RLS[Path],
MAXX(
filter(RLS,
[Employee Email] = userprincipalname()),
RLS[Full NameId]))

@. But my question now i want to assign one person on RLS to see all details in report not only related to him. Please help me this.

[TomMartens · Accepted solution]

Hey @prinuce ,

create a 2nd role, just add a simple DAX statement that always returns TRUE like 1 = 1, and assign the one person that needs to see everything to this role.

Hopefully, this provides what you are looking for

Regards,

Tom

[prinuce]

please help me. 

I have three table expenses, timesheet and services I am creating RLS in power bi need help each division have different manager each manager can see his all own division employees data of timesheet, expenses and services and employee can see only own data of this three table. i have shared the data above please check.. 

[prinuce]

@amitchandak @v-kkf-msft @v-rzhou-msft 

and online user can help.

Thank you