When I try to unify the contact entity from Common Data Service Dynamics 365 is showed the error below.
"The primary key 'contactid' of entity 'contact' in data source 'D365CustSvc' should be a string data type"
Can someone help me ?
Hello,
As far as I know from my own experiences, the field that you select as the primary key in the “Map” stage needs to be in a string/text format in Customer Insights. So, if yours is an integer or another datatype, you will have to transform that column to a string/text format. This is a system requirement. Hope this helps.
Hello Maurillio,
I would like to inform you that this is a known issue and is going to fix in upcoming releases. You won't be able to change the data type for contactId as this is disabled. There is a workaround which you can try here - create the Data Source using Import Data option and check if it helps in completing the setup.
Hi Maurilo,
By going the Import Data route and bringing in your D365 contact entity data through the Odata connector, you should be able to overcome this issue.
You can paste this in the advanced editor:
Agreed to Halen. Select Import Data>Common Data Service connector would help.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 179 Super User 2025 Season 2
#ManoVerse 110
Gerardo Rentería Ga... 61 Most Valuable Professional
