web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Map Process not read t...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Map Process not read the D365 Entities

(1) ShareShare
ReportReport
Posted on by Narendra Prasad 5

Hi,

I have the Customer Demo on this week, I tried to map the data using D365 Contact Entity and Azure SQL Data, but it's shows D365 contacts is "0" (as yellow highlight) . at map for this I  added the rule  Email matching. Finally Map process "0" recoreds is matched

I have cross verified both data sources and mail id's are exactly matching.

Instance ID : 4d00d25e-d64d-4f52-b644-8d1c52740228

Seasion id : a9d0c04e-546d-4258-a3a8-aef0c84a219e



pastedimage1611570379588v1.png

I have the same question (0)
  • Suggested answer
    tpeschat Profile Picture
    tpeschat 4,930 on at

    Hi,

    which fields did you include in your D365 Contact data source? Does any of them contain comas or line breaks?

    I had the same issue, since I included the address composite field, which contain line breaks and that messed up the match process ... Since behind the scenes CI export the data as csv and does the matching using big data technology like Spark. And this is confused with comas and line breaks ...

    There is though a setting, which can be activated by the support on your instance, which would ignore line breaks or coma's, but it has a negative impact on the performance.

    Hope this helps.

  • Suggested answer
    Aditya Kuppa Profile Picture
    Aditya Kuppa 320 on at

    Thanks Thomas.

    Hi Narendra,

    New line characters in one or more fields from the OOB Dynamics tables can be causing this issue. We can fix this by enabling handling special characters by a setting. Looking at the number of profiles you are trying to bring in from the other entity PredictedAnalysisData, I believe we should be good in terms of perf impact as well.

    We just released a newer version of the Match UI that shows more stats explaining the Match process and input and output of various steps etc. and for better debuggability. This will also help understand any further explanation on source records themselves are not coming or are they getting deduped etc.

    If you would like to enable this setting on your instance to handle new line characters, please send an email to CIHelp@microsoft.com and mention your CI instance id, and we will enable this setting.

    pastedimage1611757081600v1.png

    Thank you!

    Aditya Kuppa

    Customer Insights team.

  • McCarthy542 Profile Picture
    McCarthy542 5 on at

    It does not require to import the excel sheet in the Dynamics 365 CRM. As a Dynamics 365 Administrator you many want to test your business processes by For example, in the Lead entity, the Status field is the read-only field.

    omegle

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

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

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

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 108 Super User 2025 Season 2

#2
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 30

#3
Satyam Prakash Profile Picture

Satyam Prakash 24

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans