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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.