how do i use the CDS display name for custom entities in power bi

[steph_io]

How do I use the display name of the fields of a CDS custom entity?

I am using the Common Data Service connector in Power BI Desktop tool. When I connect to to a custom table, the Advanced setting of 'Add display column (optional)' that is default set to true, but it seems to not work. 

Is there M code or functions that I can use to import the display name of fields, rather than the cr6a2_fieldname of the cds custom entity?

Thanks

[artemus]

This happens if there is no readable fields with attributes of type Packlist, State, or Status. Can you provide a sample of the attributes on the table you are looking at?

[steph_io]

[artemus · Accepted solution]

It looks like this isn't supported directly for your dataset. You would need to create a manual query to CDS to get the mapping from name to display name.

The URL for getting this data would look something like (you can use a network sniffer or possibly look at the logs to find this out):

https://endpoint.com/EntityDefinitions

Query:

$select=Attributes

$expand=Attributes($select=AttributeType,LogicalName,IsValidForRead)

$filter=SchemaName eq <your schema>

Headers:

Accept=application;json;odata.metadata=none

OData-MaxVersion=4.0

Perfer=odata.include-annotations="-*"