CRM-side blockers preventing attributes to be exported using Azure Data Factory?

(0) Share

Report

Posted on by Community member

Hello,
Related entity: Opportuntiy

related attribute: accountid

I am trying to do a copy job in Azure Data Factory where I want to copy the entire opportunity entity into a azure sql database.
The problem is if I use the auto create table to create the recieving table, or creating the recieving table myself I get the accountid attribute over but with all null values.

If I try to xml query the data over I do not even get the accountid attribute over.

I can read the accountid attribute just fine using SSMS.

Does anyone have experience with this sort of problem and/or knows if there are blockers preventing the accountid data from being /released/ from the CRM environment?
(In the azure data factory source preview window I see the attribute but no data)

Any help is appreciated :)