Skip to main content

Power BI

Needs Votes

Expose an oData datasets "instance annotations" in PowerBi

Vote (16) Share
Sean's profile image

Sean on 16 May 2016 20:49:14

Expose OData "instance annotations" within PowerBi. PowerBi allows us to can include annotations in (example with a broken URL: = OData.Feed("https //org.crm.dynamics.com/api/data/",[#"Prefer"="odata.include-annotations=""*"""])). However, even though instance annotations are provided in the response, there is not a way to surface them within PowerBi. Please allow the use of a function or method to expose and use Instance Annotations provided in oData responses. Thanks!

Comments (3)
Sean's profile image Profile Picture

Sean M. on 05 Jul 2020 23:06:48

RE: Expose an oData datasets "instance annotations" in PowerBi

FYI - here is a reference to how Dynamics 365 users the Prefer and odata.include-annotations: https://msdn.microsoft.com/en-us/library/gg334767.aspx#Anchor_11

Sean's profile image Profile Picture

James Feek on 05 Jul 2020 22:45:46

RE: Expose an oData datasets "instance annotations" in PowerBi

I notice that OData.Feed has an explicit option to include annotations (see https://msdn.microsoft.com/en-us/library/mt260868.aspx): IncludeAnnotations : A comma separated list of namespace qualified term names or patterns to include with "*" as a wildcard. By default, none of the annotations are included. However, there still does not seem to be way to surface those annotations. What is the purpose of the IncludeAnnotations option?

Sean's profile image Profile Picture

Sean McNellis on 05 Jul 2020 22:21:50

RE: Expose an oData datasets "instance annotations" in PowerBi

For Dynamics CRM folks, this would allow you to have lookup value primary field, and optionset labels provided for each value within the response when using the v4 WebApi (https:// org.crm.dynamics.crom/api/data/).