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
v-yulgu-msft Super Contributor
Super Contributor

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
v-yulgu-msft Super Contributor
Super Contributor

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!

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 176 members 1,759 guests
Please welcome our newest community members: