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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Imagauthamam
Helper II
Helper II

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.