Anonymizing data in Power BI
One of the possible scenarios that could happen to you during your career as a report developer in Power BI is the following. Imagine that you are given an Excel dataset to import into Power BI to create a report for another department in your company. The Excel data set contains sensitive personal information, such as the names and email addresses of people who have made multiple attempts to pay for an order with a credit card. The following is an example of the contents of the Excel file:
You are asked to create the report while anonymizing the sensitive data.The first thing you will notice is that, not only do you need to anonymize the Name and Email columns, but some names or email addresses can be contained in the text of some Notes. While it is quite easy to find email addresses using regular expressions, it is not so easy to find names in free text. For this purpose, it is necessary...
