Skip to main content

Power BI

Needs Votes

OData.Feed should support entity bound function with same name as property

Vote (50) Share
Dave Brann's profile image

Dave Brann on 11 Oct 2019 01:42:37

Microsoft case 119083024001340 was filed for an issue causing a failure in OData.Feed when reading valid OData metadata. Microsoft Product Group agreed there is an issue but will not fix it unless there is sufficient votes.

The issue occurs if an OData entity, lets call it MyNamespace.E1, has a property named JobStatus and there is also a bound function also named JobStatus that is bound to MyNamespace.E1. In this case, when OData.Feed reads $metadata from the OData API, it throws an exception:
[Expression.Error] The field 'JobStatus' already exists in the record.StackTrace: at Microsoft.Mashup.Engine1.Runtime.KeysBuilder.Add(String key).

Again, just to be clear, Microsoft Product Group agrees this is an issue in OData.Feed where they cannot handle duplicate column names that would be created from both property and bound function. I suggested they just append a "_function" string or similar to the end of the JobStatus function (rename JobStatus to JobStatus_function) to eliminate the duplicate name. Microsoft will not do this unless there is sufficient votes.

Please vote!!!
Thanks,
Dave