CDS Field Display Names

[Anonymous]

I'm using the Common Data Service connector.  Is there a way to pull in field display names from a CDS entity? 

I'd like to save some work in manually renaming my columns.  (For example, "Modified By" instead of "modifiedby".)

[v-juanli-msft]

Hi @Anonymous 

You could try to manage the field names in Power Apps, then refresh on Power BI Desktop.

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-manage-fields#update-or-delete-a-field

Please pay attention to the restricitions.

Or you could rename columns' names in Power Query(Edit queries).

References:

https://community.powerbi.com/t5/Desktop/Auto-renaming-columns-based-on-value-in-another-table/td-p/79018

https://www.thebiccountant.com/2018/07/04/efficiently-rename-column-names-with-a-function-in-power-bi-and-power-query/

https://exceleratorbi.com.au/renaming-all-the-columns-in-a-table-at-once-using-power-query-m-language/

https://www.fourmoo.com/2018/05/15/power-query-renaming-multiple-columns/

If you have any problem, feel free to ask me.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Thanks for the feedback.  I'm currently manually renaming the columns with friendly field names -- was just hoping there was some additional info I could pull through the CDS integration which would allow me to access the friendly field names which are already specified in my CDM entities.

I ended up finding a way to accomplish this through the Power Query Builder plugin for XRM ToolBox.  It outputs the M Code (with friendly field names) which I can then paste into Power Query.