Forum Discussion
Anonymizing data ?
I'm working on a set of chart to manage a group of car dealers
The idea is to show a serie of bar and bullet chart so each dealer can know how well they performed compared to other
Problem : dealer cannot be allowed to see any data or name but their own.
For example, one of the bar chart shows marketshares, ordered by the highest to the lowest.
Each dealer should be able to see its own rank and performance but should not know who is any of the other bar.
Does someone know if it's possible and how ?
Hi Arkhos94 ,
It seems that you want to restrict each dealer to only view their own data, but also show their ranking and percentage among all dealers and hide the information of other dealers. Please check the following blog to see if you can achieve your needs by using RLS and creating a Copy of the Table with the Confidential Data.
Row-level security (RLS) with Power BI
Secure the Sensitive Data in Power BI; Data Masking better with Row-Level Security
Best Regards
3 Replies
Arkhos94 , create another summarized table without dealer and join it with common dimensions other than the dealer and then secure dealer dimension using RLS and created market sharing suing the new table
thanks for your help
I'm not sure I understand everything through
Creating a summarized table I understand. But I don't understand how I can do it without dealer. Can you explain more ?
Hi Arkhos94 ,
It seems that you want to restrict each dealer to only view their own data, but also show their ranking and percentage among all dealers and hide the information of other dealers. Please check the following blog to see if you can achieve your needs by using RLS and creating a Copy of the Table with the Confidential Data.
Row-level security (RLS) with Power BI
Secure the Sensitive Data in Power BI; Data Masking better with Row-Level Security
Best Regards
