CODEWITHSUNDEEP
powerbiodatax++erpdynamics-365-operations
Ivan Pk
Ivan Pk

Reputation: 1

D365 FO / Odata error : unable to resolve the type name '' to an EdmType

I am making a PowerBI Report about time sheets from Dynamics Finance Operation but i can't see the "Hours" columns (1 column by day of the week, with a number of hours worked). It is an array with 7 days, made as an extended data type.

When I Query on SQL Server , i see the 7 fields Hours.

SQL Server

in Odata, it is not showing in Power BI or Excel with Odata from the data entity i created. i see all other fields , except the Hours fields (extended data type). I can also have the error "unable to resolve the type name '' to an EdmType"

I created a Public data entity from TSTimesheetLineEntity (the data entity exists but is not public), the field "Hours" that i can't reach is in the table TSTimesheetLineWeek. I also tried to only create a data entity from the table TSTimesheetlineWeek but i have the same issue.

Extended Data Type

Hours parameter

Data entity TSTimesheetLineEntity

Any help would be appreciated, I am new on D365 :)

Upvotes: 0

Views: 594

Answers (1)

FH-Inway
FH-Inway

Reputation: 5117

Unfortunately, the Hours field is an array field. Those are not supported by OData. See Array fields - Open Data Protocol (OData):

OData does not support array fields in entities. This must be taken into consideration when designing entities that will be used with OData.

This would require a customization. One option would be to add Hour1-7 fields to the entity and add logic to the entity that populates those fields when the entity is called.

Upvotes: 0

Related Questions