Forum Discussion

Koritala's avatar
Koritala
Post Patron
1 year ago
Solved

Data Masking In Power BI Table visual

Hi All,   I need urgent help to mask the PII data in my Table visual for the personal data-related columns in my power bi report.   I have 2 types of users.  1. PII Users 2. Non-PII Users   i...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Koritala ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you Ritaf1983 Thejeswar for the prompt response.

    I have created PBIX file using sample data for Dynamic masking.Please go through the attached PBIX for your reference, even I have tested by replacing USERPRINCIPALNAME() with the email id existing in my UserAccess table.It worked for me.

    It shows real data for users with "Y" in IsPIIUser.

    It shows asterisks for users with "N" in IsPIIUser.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

    Thank you.

Ritaf1983's avatar
Ritaf1983
Super User
1 year ago

Hi Koritala 

In Power BI, there is no native support for masking column values like "XXXXXX" based on user type. What you can do instead are the following two approaches:

  1. Row-Level Security (RLS) – You can restrict entire rows based on user access. However, this won't allow you to show/hide or mask specific column values based on user identity. Column-level security is not natively supported.
    More information is by the link:
    https://www.youtube.com/watch?v=jphj40tBPD8

  2. Separate Report Versions – You can create two versions of the report: one for PII users and another for non-PII users (where sensitive columns are removed or replaced with placeholders). Then, use audience targeting in the Power BI app to share each version with the appropriate group.
    https://www.youtube.com/watch?v=nchNa44o2D4

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly