Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
dennisr
Advocate II
Advocate II

Dynamics CRM - can we get Display Name of columns rather than Logical Names?

Is there some way to get Display Name of columns rather than Logical Names?

2 REPLIES 2
KHorseman
Community Champion
Community Champion

Not directly, but maybe if you're really ambitious... If you're connecting to CRM in a way that gives you access to AttributeView you might be able to write some creative M code to replace column names using that. Maybe filter AttributeView by EntityID (you'll have to look up the EntityID for whatever table you're querying. I think the table for that is EntityMap or something like that Edit: haha nope it's EntityView), then pull the Name and PhysicalName columns, and load them into a list, then query the table you actually want, then write a rename columns function that calls that list. It would be a pretty hairy query to write.

 

Edit edit: though now that I think about it, Display Name doesn't actually map directly to a field. It's per-form. The same field can have multiple different display names depending on the form it's displayed on. Which means this won't work. You'd have to check the mapping for the specific form you want to get the display name for, and I have no idea where that mapping is. But I suspect it's even more inconvenient than what I've already described.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Connecting Power BI to Dynamics online uses ODATA.  So, I don't have access to the SQL tables.  (What is "M code"?)   I found a workaround that uses XrmToolBox to Export to Excel which does use the Display Names defined on the entity fields.  So, rather than a data source that connects directly to Dynamics, it connects to the Excel sheet.  

(I guess I will just need to post an 'idea', to get this feature. 😉

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors