News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Data Export Service no...

Microsoft Dynamics CRM (Archived)

Data Export Service not pulling Lookup fields display 'name' column in Azure SQL DB

(1) Share

Report

Report

Posted on by Sachin Dev Gupta

I have noticed that Data Export Service is not pulling display 'name' text value of a lookup field in Azure SQL DB. Is this is an expected behavior?

Example:

accountId	7F399A97-38FC-E511-80CF-XXXXXXXXXX
accountId_entitytype	account
accountIdname	Need to retrieve Name using lookup ID and entitytypename.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Hugo Herrera 60 on at

Like (1)

Report

RE: Data Export Service not pulling Lookup fields display 'name' column in Azure SQL DB

Hi Sanchin, did you manage to get the lookup name fields populated in the end?
Suggested answer

Daniel Wikell 2,360 on at

Like (1)

Report

RE: Data Export Service not pulling Lookup fields display 'name' column in Azure SQL DB

I notice this behaviour too in one of my setups. It sounds like a bug since the corresponding yomi name is actually populated!

I would suggest raising a support ticket with MS regarding this. As a workaround in the meantime perhaps you can use the accountidyominame field instead

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,403 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans