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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
jzimmem
New Member

RLS to To Disable Column (Field) Usage

Odd question, but has anyone have any ideas of how to hide a field in it's entirety using RLS. For example I don't want a particular set of users to see a column named Gross Margin.

 

Thanks

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

@jzimmem that is indeed odd one. RLS is for row level security and what you're wanting is to hide column. I think closest you can get is hide actual column in pbi desktop by right click column and Hide and create two set of reports. One for normal users and other for users you want to hide that column.

View solution in original post

2 REPLIES 2
ankitpatira
Community Champion
Community Champion

@jzimmem that is indeed odd one. RLS is for row level security and what you're wanting is to hide column. I think closest you can get is hide actual column in pbi desktop by right click column and Hide and create two set of reports. One for normal users and other for users you want to hide that column.

Can this still be achived???

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.