Make a field restricted based on a user/group

[sokatenaj]

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!

[v-yulgu-msft · Accepted solution]

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

[sokatenaj]

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