Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.