Forum Discussion

DCELL955's avatar
DCELL955
Copper Contributor
Dec 08, 2023

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?

  • bhaso's avatar
    bhaso
    Copper Contributor

    It maybe because of column level security.  Compare the security of column which has issue with other columns.

Resources