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.

Thejeswar's avatar
Thejeswar
Super User
1 year ago

Hi Koritala ,

You can use the REPT() DAX function to perform Data Masking of a certain column like shown below

 

For example,  I am masking the food supply level column. You can use substring to control the number of characters that you want to mask 

MaskedData = REPT("*", LEN([Food_Supply_Level]))

 

Using Substring:

 

 

If this helps, Accept this as a Solution and Appreciate with a Kudo!

 

Regards,

  • Koritala's avatar
    Koritala
    Post Patron
    1 year ago

    Hi, it should be dynamic masking not static