web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... How to extract Virtual...

Microsoft Dynamics 365 | Integration, Dataverse...

Unanswered

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

(0) Share

Report

Report

Posted on by Ib Ninja

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.

I have the same question (0)

All responses Img

All responses (0)

Answers Img

Answers (0)

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

Martin Dráb 41 Most Valuable Professional

#2

#3

Satyam Prakash 35

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans