Forum Discussion
DCELL955
Dec 08, 2023Copper Contributor
Columns from D365 CRM not found
Hello,
I want to copy data from D365 CRM Opportunities into an Azure SQL table on a schedule.
When I connect to our company.crm.dynamics.com using SSMS, I am able to do a SELECT DISTINCT statecode, statecodename FROM opportunity and get results for both columns. Other out-of-box columns follow the same pattern where there is a xxxcode and a xxxxcodename column pairs.
However, in ADF when I have D365 CRM Opportunities as a source, and the Azure SQL table as a sink, and I go to verify mapping, statecode is found but statecodename is not, and many other 'xxxxxxxxname' columns are not found either. Why is that?
- bhasoCopper Contributor
It maybe because of column level security. Compare the security of column which has issue with other columns.