Forum Discussion

Phantom1980's avatar
Phantom1980
New Member
3 months ago
Solved

Role Level Security

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, T...
RLS
  • grazitti_sapna's avatar
    grazitti_sapna
    3 months ago

    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!

grazitti_sapna's avatar
grazitti_sapna
Super User
3 months ago

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!