Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Power BI - Using DAX, how can I check which Role (from Row Level Security) the user is using?

Hi,

I have created four Roles (Full Company, North, South East, and South West) via Row Level Security. The way this RLS will be implemented is by assinging the user email address (userprincipalname) in the Power BI Service against the Role. When a user logs in using their userprincipalname the correct Role will be assigned to the user and thus they can only see their granted data.

I would like to know if there is a way, using DAX, to check which Role name (i.e. Full Company, North, South East, or South West) is being used - what would be the DAX to achieve this?

My aim is to provide a tailored message, via a card or another visual, that will instruct the user based on the role being used. For example, is the North Role is being used when viewing the report then a message like "This North region will show you.....", or if the South East Role is being used a message like "The South East region incorporates...".  I suspect a Switch function will be require but the key thing is using DAX to check which Role is being used by the user.

Thanks in advance.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @judspud - thanks for your response but I have it all sorted now.
I was overthinking it. I simply used the SELECTEDVALUE function on the table that the Role (RLS) was applied against.

 

 

View solution in original post

2 REPLIES 2
judspud
Solution Supplier
Solution Supplier

Hi @Anonymous 

 

How are you implementing the RLS? i.e. which table/field are you using to filter the data?

 

Also, can a user be part of multiple roles?

 

Thanks,

George

Anonymous
Not applicable

Hi @judspud - thanks for your response but I have it all sorted now.
I was overthinking it. I simply used the SELECTEDVALUE function on the table that the Role (RLS) was applied against.

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.