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

Anonymising names

We have a report that shows our KPI's and an individuals performances against those KPI's. This report shows all the employees along with their names so anyone can see how everyone else is performing.

 

We have had a request from an employee that they want to invoke their right to privacy under GDPR and be removed from these reports and our HR seem to agree with this.

 

This is on a report that is manually put together at the moment but we are working on automating this via Power BI and the current design rightly or wrongly has not accounted for this sort of request as its a very open culture on performance and stats.

 

We still want employees to be able to see how they are performing compared to their colleagues so we still need to display other peoples figures. So is there a way that the person viewing the report can see their name but the names of their colleagues would be asterisk's? That way we're anonymising the data of the other employee's?

 

If this is not possible then guides on row level security that show/demo how managers can see their teams data but front line colleauges can't see their colleagues data would be appriciated.

3 REPLIES 3
Stachu Super Contributor
Super Contributor

Re: Anonymising names

have you considered applying row level security on individual data and then creating anonymized benchmark dataset available to everyone? that's how I would approach it, but I must say I'm really curious what others have to say

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Re: Anonymising names

I thought RLS would be the answer. Could you point me in the direction of any guides on what you have advised?

Stachu Super Contributor
Super Contributor

Re: Anonymising names

try this
https://docs.microsoft.com/en-us/power-bi/service-admin-rls

 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 43 members 1,124 guests
Please welcome our newest community members: