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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

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

(0) ShareShare
ReportReport
Posted on by
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 :)

 
I have the same question (0)

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 197 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 70

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans