cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sokatenaj Member
Member

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

Accepted Solutions
Community Support Team
Community Support Team

Re: Make a field restricted based on a user/group

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.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Make a field restricted based on a user/group

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.
sokatenaj Member
Member

Re: Make a field restricted based on a user/group

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