web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Can we anonymise data ...
Customer experience | Sales, Customer Insights,...
Suggested answer

Can we anonymise data in Customer Insights for non-production environments?

(0) ShareShare
ReportReport
Posted on by C2020 25

If you have multiple environments within Customer Insights is there common scripts or functionality to anonymise production data in non-production environments?

So, rather than me in a non-production environment looking at real data for a customer with their email address, social handles etc. can this be anonymised to Joe Bloggs?

As this data is stored at a data lake level I suspect so, but is that then supported?

Do we have direct access through to the data lake to access and anonymise this data?

I have the same question (0)
  • Suggested answer
    Kasunpathirana Profile Picture
    Kasunpathirana 277 Most Valuable Professional on at
    RE: Can we anonymise data in Customer Insights for non-production environments?

    Hi C2020,

    This is a great question indeed and there is no OOB feature at the moment. But this could be something which will add great benefit with all the regulations and GDPR in place. As Halen mentioned we can use Power Query and the other options mentioned to achieve some of this result.

    I would suggest you to to create an new idea if this is already not existing in the idea portal.

    experience.dynamics.com/.../

    Thanks,

    Kasun

    The reply is solely my personal opinion. It doesn't reflect my employer or Microsoft opinion.

    my D365 related web site link is below

    D365Blog

  • Community Member Profile Picture
    Community Member on at
    RE: Can we anonymise data in Customer Insights for non-production environments?

    Hi C2020,

    This is a good point you raise.

    The simple answer to your question is to undertake a few simple transformations using the power query functionality in Customer Insights when editing a data source.

    I can think of a few options to anonymise your data, such as removing fields, extracting specific strings from fields, or adding characters to fields to 'contaminate' the data and render it null.

    For example, you could remove the name field and personal ID fields completey. The add an indexed column to represent your new unique ID provided you do not have duplicates in that table. Email addresses can be extracted before or after '@' , and mobile numbers could be edited by adding or removing digits.

    As far as out-of-the-box functionality goes, I am not aware of anything in Customer Insights that does this automatically.

    Alternatively, you can also point your sandbox CI environment at your dev or UAT environment where you are reading your data.

    Kind regards,

    Halen

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 141

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 132

#3
DAnny3211 Profile Picture

DAnny3211 130

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans