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
9 months ago

Hi Venu,

The code which you provided for the data masking in table visual based on user type login is giving some issue.
In my report I have a slicers like employersname and Members slicers along with date range slicer. Members slicer will show the coressponding members for the selected Employersname slicer.
I created measure logic for my required columns as per your code provided. The issue is when I drop the firstname masked cloumn which I created, that is not filtering the visaul data as per the employername and Members slicers. For example for X employer there are 2 Members. But when I place the newly created Firstname masked column, it pulling all the records from the backend.

Can you please suggest how to proceed in this scenario.

Thanks,

Sri.