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

All responses (1)

Answers (1)

Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Power BI - Get Data for Custom Entities

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