cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

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

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="-*"

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

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

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?

Highlighted
Advocate II
Advocate II

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

CDS Budget Project Entity.PNG

Highlighted
Microsoft
Microsoft

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

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="-*"

View solution in original post

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021