Power BI - Get Data for Custom Entities

(1) Share

Report

Posted on by Brendaama

I had an issue with bringing choice/option set values into Power BI to display as the text and not numbers, which was solved using this write up: d365 - Multiselect Option Set (google.com). However, only the extract stated below was helpful for me because I used delimiter to solve the others

One of the key components to getting the label information into Power BI is to use the odata.include-annotationsodata.include-annotations=/OData.Community.Display.V1.FormattedValue/ as the Prefer Header in the Web Data Source. This would assist us to get the underlying text (label) of the OptionSet. On the right is a screenshot of a simple example.

This solution worked perfecting well for the incident table but I am unable to use this solution for custom entities.

Specifically, when I was to get the data from the incident table (OOB entity, i used this method, as seen in the screen shot belowwhen I try using same method to get data for a custom entity, I get the error message below:

Please help

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Hi Partner,

You should use the correct form of the entity name on the URL: Plural forms of logical name.

For example:

My custom entity logic name is crb1f_backlog:

so i need use 'crb1f_backlogs' on the url:

As corroboration, I use incident directly this error comes up:

I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No