Role Level Security

[Phantom1980]

Hi,

I haven't been using power Bi too long and I have a RLS question. I tried using Claude but with no success. My question is as followed:

I have a stats table with the following fields: Period, TkD, Name, Hours and Amount.

When user A logs in, I only want user A to see his information along with user B and C.

When user B logs in, I only want user B to see his own info and no one else.

User C can see everyone's information including his own.

What do I need to do to set up this kind of RLS? Thanks.

Jack

[v-anbandari]

Hi @Phantom1980,

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions. Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[v-anbandari]

Hi @Phantom1980,
 

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to the @cengizhanarslan  and  @grazitti_sapna  for sharing valuable insights.
 

Could you please confirm if your issue has been resolved using the suggested approach? This will help other community members facing similar scenarios.
 

Thank you.

[cengizhanarslan]

You need a mapping table that defines which user can see which names. This gives you full flexibility without creating a separate role for every user.

1) Create a new table in Power Query (or as an Excel/CSV source) called RLS_Mapping with two columns: UserEmail and AllowedName.

2) Create a relationship from RLS_Mapping[AllowedName] to your stats table's Name column (many-to-one, single direction from RLS_Mapping to stats table).

3) In Power BI Desktop, go to Modeling → Manage roles → New role. Name it something like "DataAccess". On the RLS_Mapping table, add this DAX filter:

[UserEmail] = USERPRINCIPALNAME ()

4) Publish to the Power BI Service. Go to the semantic model → Security → assign all users to the "DataAccess" role.

[grazitti_sapna]

Hi @Phantom1980,

You can create a mapping table with type of access to be provided.

Refer Sample .pbix file for reference. (Tested with View role as)

if you have the heirarchial data then you can explore PATH and PATHITEMS functions

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!