I am facing issue on Row level security

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-to-Many Relationship - Part 1 - RADACAD

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

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