Skip to main content
Dynamics 365 general forum

How to extract Virtual columns from Dynamics using Azure Data Factory (ADF)

editSubscribe (0) ShareShare
Posted on by

Is there a way to pull virtual column values from Dynamics using Azure Data Factory (ADF)? For example, in addition to OwnerId column, i also want to see OwnerName. Currently, when i pull data on ADF using the Dynamics connector, I only get the ID/GUID, and no name columns. This is a real limitation because it means the only way to get the name columns is to do many joins (hundreds).

Any alternative suggestions to ADF would also be appreciated. 

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…


Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans