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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sokatenaj
Helper III
Helper III

Make a field restricted based on a user/group

Hi Folks,

 

Quick question. Is there a way to do restrict a field by a user role? For example, I have 10 people in a group called "HR All" and they can see all people and salaries. I then have another group called "HR Restricted" which these people cannot see certain people. However, in addition to not seeing different people I also do not want them to see salary.

 

Is this possible? The only logical way I can think of it is to create a different table with employee ID, hourly rate, and salary to create a relationship with the employee table, but then I get the error that I can't create a relationship because there are no unique values!

 

Please help.

 

Thanks!

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @sokatenaj,

 

Based on my understanding, you want to hide some fields for some certain people whih looks like column level security, right? However, Power BI only supports Row-level security. Here is an idea you can click to vote it up.

 

If I have something misunderstood, please provide more description about your expected result. And provide detailed sample data as I cannot imagine your table structure and don't know how you created relationships.

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @sokatenaj,

 

Based on my understanding, you want to hide some fields for some certain people whih looks like column level security, right? However, Power BI only supports Row-level security. Here is an idea you can click to vote it up.

 

If I have something misunderstood, please provide more description about your expected result. And provide detailed sample data as I cannot imagine your table structure and don't know how you created relationships.

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you. That is what I was referring to. Many thanks!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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