Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0

OData.Feed and Value.Metadata doesn't show annotations metadata

I have an OData API that has metadata annotations.   I am using OData.Feed with the following options:

[ODataVersion = 4.0,
MoreColumns = true,
Implementation = "2.0",
IncludeMetadataAnnotations = "Org.OData.Capabilities.V1.*,Com.Ingr.Core.V1.*",
IncludeAnnotations = "Org.OData.Capabilities.V1.*,Com.Ingr.Core.V1.*"]

 

My OData metadata has the following metadata segment:

<EntityType Name="PlatePart" BaseType="Com.Ingr.Smart3d.V1.ShipStructurePart" Abstract="true" OpenType="true">
<Property Name="StructuralPriority" Type="Edm.Int64">
<Annotation Term="Com.Ingr.Core.V1.DisplayName" String="Structural Priority"/>
<Annotation Term="Com.Ingr.Core.V1.SelectListId" String="CMNSCH-StructuralMemberPriority"/>
</Property>

 

From Power BI M language, I expect to use Value.Metadata on the StructuralPriority column and see the annotations available on the column.
Howerver, using this:

 

let
Headers = [Authorization = "Bearer eyJ0eXAiOiJK........Ijoi9NidVbWa0eTz1QhA"],
Options = [ODataVersion = 4.0, MoreColumns = true, Implementation = "2.0",
IncludeMetadataAnnotations = "Org.OData.Capabilities.V1.*,Com.Ingr.Core.V1.*",
IncludeAnnotations = "Org.OData.Capabilities.V1.*,Com.Ingr.Core.V1.*"],
Source = OData.Feed("https://s3dwebapisam.ingrnet.com/s3d/v1", Headers, Options)
Sites_table = Source{[Name="Sites",Signature="table"]}[Data],
defwsbindatp_sdb = Sites_table{[Id="defwsbindatp_sdb"]}[Plants],
DefWSBindATP = defwsbindatp_sdb{[Id="DefWSBindATP"]}[PlateParts],
StructuralPriority = DefWSBindATP[StructuralPriority],
md = Value.Metadata(StructuralPriority)
in
md

only the QueryFolding metadata is returned and nothing else. Should Value.Metadata return OData metadata annotations? If not, how do I get metadata annotations in M langauge if Value.Metadata doesn't work?

 

Thanks,
Dave

Status: Delivered
Comments
v-yuezhe-msft
Employee

@DaveTheOx ,

Please open a support ticket in Power BI support site.
Support Ticket.gif

Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Delivered
 
DaveTheOx
Regular Visitor

@v-yuezhe-msft , I filed a support ticket.   Thanks.