• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog
  • Power Platform
    • Power Apps
    • Power Automate
    • Power BI
    • Power Virtual Agents
  • Dynamics 365
  • Azure
  • About Me
Joe Gill Logo

Joe Gill

Microsoft MVP - Power Platform Consultant

Home » Power Platform » Dataverse Anonymization

Dataverse Anonymization

25th April 2022 by Joe Gill

Many organizations require that personal data in non-production Dataverse environments is anonymized. This may be company policy or a legal requirement such as GDPR which governs the collection and processing of personal information in the European Union. Here is a quick tip on how to use the Bulk Data Updater for XrmToolBox to anonymize Dataverse data. In case you are not familiar with the Bulk Data Updater, it was developed by the wonderful Jonas Rapp and it allows you to query and update Dataverse records in bulk. Full instructions on how to use it are available on Jonas’s site

While there is no random character generator functionality in the Bulk Data Updated it does contain a generic string substitution functionality in the form of XRM Tokens. These can be utilized to anonymize Dataverse data. There are different types of tokens and they are all detailed here

To use an XRM Token simply select the field you want to anonymize, in Bulk Updater, and change the type of update to calculated. Enter the XRM Token you want to use in the text box. In this example, I am replacing the last name with the first letter of the last name followed by the guid of the contact id. If you are happy with the expected result then select Add Attribute to include it in the fields to be updated

Dataverse Anonymization Joe Gill Dynamics 365 Consultant

There are lots of options you can use with XRM Tokens including sequences and I have used use this option for email addresses e.g. {lastname|}[#|1001|0000000]@example.com. You can also use conditional substitutions for example you can check if a field is not null and update if it is not.

<iif|{emailaddress1}|neq||{emailaddress1|<Left|1>}2{contactid|<Left|10>}@example.com|no email|>

Once you have configured which fields you are anonymizing then select the update records option. You may want to increase the batch size for better performance.

Dataverse Anonymization Joe Gill Dynamics 365 Consultant

Once your update has run your contact data will be anonymized. Don’t forget to clear down your audit table.

Dataverse Anonymization Joe Gill Dynamics 365 Consultant

I hope you found this quick tip on how to anonymize Dataverse useful. If you use XrmToolBox or Bulk Updater please consider making a well deserved contribution to the authors.

Share This On Social:
  • Tweet
  • Dataverse Anonymization Joe Gill Dynamics 365 Consultant

Filed Under: Dataverse, Power Platform

Primary Sidebar

Popular Categories

  • Power Platform
    • Power Apps
    • Power Automate
    • Power Virtual Agents
  • Azure
    • Logic Apps
  • Dynamics 365
  • .NET
  • AI
  • SQL

More to See

Power Platform Requests – Base Request Capacity

17th December 2020 By Joe Gill

Power Automate Desktop

Power Automate Desktop – UI Flow

26th November 2020 By Joe Gill

Datavseres Metadata - Azure Synapse

Dataverse Metadata in Synapse

17th January 2022 By Joe Gill

Azure Synapse Link for Dataverse Tables

Synapse Link for Dataverse – Option Sets

22nd December 2021 By Joe Gill

Tweets

Footer

Joe Gill

Microsoft Business Applications MVP – Power Platform, Dynamics 365 and Azure.

An architect with over twenty years experience designing and developing technology solutions. Specializing in the Microsoft technology stack including Power Platform, Dynamics 365 and Azure. Microsoft MVP Profile

Connect on Social

Useful Links

  • Home
  • Blog
  • About Joe Gill
  • Power Platform
  • Dynamics 365
  • Azure

Featured Posts

Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

Dataverse Anonymization

Dataverse Metadata in Synapse

Synapse Link for Dataverse – Option Sets

Custom Pages – Multiple Screens

© 2022 · Joe Gill