Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Data masking for Excel data

Hi Team, I am new to power BI. I am working on a Telecom client. I have 2 tables which is linked on the confidencial field (MSISDN: Telephone no.s of customers). I want to data mask this field in th...
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous

    You may try to use hide in report view function to hide the field before you publish the report to Power BI service,

It will not be seen in the Power BI service.

And you can also try to merge two table in Edit Queries by the confidential field and then remove this field.

 

Best Regards,

Lin

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-lili6-msft

    Sorry for the late reply and thank you for answering. But i dont want to hid the column in the report. I want to show the encrypted value of that column in the report. any more suggestions??

     

    Regards,

    Priya