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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
NandanHegde
Super User
Super User

Identify which Role user is assigned to

Hello All,

Is there any way to identify which Role a user is added to?
Because based on the user role, we need to make a measure which would display values if added in Role1 else woudl display it as blank.

The main thought behind this is we need to have a column level security wherein a column value needs to be displayed only for certain users and for all other resources it should be blank.

 

Note: I cannot create a user mapping table within the modle as the users list is controlled within a DL by the business




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
1 REPLY 1
Preeti_Yadav
Resolver I
Resolver I

Hi @NandanHegde 
You can reffer the following link for the column level security,this might help you:
https://community.powerbi.com/t5/Community-Blog/Column-Level-Security/ba-p/1309392 

Thanks!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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