Masking of Sensitive Data

[Heena_9980400]

Hi Experts,

I have a requirement in our project, as I am creating Adhoc reports(there are no measures or filters or any logic).
 The requirement is like "For a particular report user A will be able to see all fields including PII but user B will see only the non-PII fields; other fields will be masked for them. Then B will be able to download the report but A can download the report with PII attributes as masked"(While export).
Looking Forward to your response.

Thanks,

Hina

[dcrosseto]

Hi Heena,

For security, you can make use of OLS (Object-Level Security) functionality, where you can enable specific tables or columns from report viewers, check below two links, one from Microsoft and one good tutorial as example

Announcing public preview of Object-Level Security in Power BI | Microsoft Power BI Blog | Microsoft...

Configure OLS in Power BI using Tabular Editor to limit access to non-financial measures - FourMoo |... 

Regarding to downloading or not, you can use the checkboxes at the time you grant permission to the specific users, not sure if you can create a group A/B with those patterns.

Hope that helps.

Regards,

Douglas.