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.

All responses Img

All responses (0)

Answers Img

Answers (0)

Helpful resources

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

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

#1

Siv Sagar 149 Super User 2025 Season 1

#2

Muhammad Shahzad Sh... 67 Most Valuable Professional

#3

Mansi Soni 63

Overall leaderboard

Featured topics

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