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.

v-venuppu's avatar
v-venuppu
Community Support
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.

Koritala's avatar
Koritala
Post Patron
1 year ago

Hi Venu,

Appreciate your solution. it is working as expected. Thanks for your support.