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
Imagauthamam
Helper I
Helper I

Column Level Security in Power BI

We have 100's of columns in our fact table.
We want to expose a sensitive column to only few users.
I checked online and found the below video where it is explained using OLS Using Tabular Editor.
https://www.youtube.com/watch?v=G3_Gu5FTUhw

Herein, I have to create a role and the users that I put in this role will not be able to see the column.
This is the main issue because we have thousands of users and only 5 people need access to this column.
It's not possible to enter each of them manually.
On the flip side, do we have any workaround like we can create a role and the users that I enter in that role should only have access to those columns?
Please check and let me know if you have any suggestions.

3 REPLIES 3

@Imagauthamam , i am mentioning about security groups in the Microsoft Admin Center. But it is not possible to restrict access other than the selected 5 users. 

As per the screenshot below when you click "display name" checkbox all the users will be selected uncheck the 5 users and create the group.  

SanthiyaMallow_0-1699748733703.png

 

Hi @Imagauthamam , You can use security groups where you can add all the users in a tenant at a time and after adding all the users, you can search in the directory to uncheck the users to whom you want to give access to the sensitive data. 
You can use the same security group for other dataset by creating the security group one time

Hi @SanthiyaMallow 
Thanks for the response.
Are you mentioning AD Groups?
In that case also, I believe I have to create an AD Group containing all users.
Because out of 1000 users, I have to create an AD Group for 995 people.
Instead of this,If I create an AD Group only for 5 people for which access is required, Can I use it somehow to give access to sensitive column only to these 5 people?

 

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.