Hello All,
I’ve ran into an issue working with OData feed. If an entityset declares IncludeInServiceDocument="false", PowerBI fails to connect to the service. If IncludeInServiceDocument="true", everything works fine.
The Odata service i'm developping has bound functions that return a new entityset:
Entity set A --> bound function which returns a new entity set B. I don't want the user to see enitity set B when he connects to the service. He should only be able to access it through the bound function. If i set IncludeInServiceDocument to "true" in the metadata, the enitity set B is displayed and accessible to the user directly from the first view when he connects to the service. If i set IncludeInServiceDocument to "false", PowerBI displays an error and fails to connect to the OData service. Is that normal or is there a bug ?
The metadata looks like this:
<edmx:DataServices>
<Schema xmlns="http://docs.oasis-open.org/odata/ns/edm" Namespace="IVserver.odatasrv">
<EntityType Name="is_reporting">
<Key>
<PropertyRef Name="Id"/>
</Key>
<Property Name="Id" Type="Edm.Int32"/>
<Property Name="DisplayRate" Type="Edm.String"/>
<Property Name="Oldest" Type="Edm.DateTimeOffset"/>
<Property Name="Newest" Type="Edm.DateTimeOffset"/>
</EntityType>
<EntityType Name="is_reportingData">
<Key>
<PropertyRef Name="Instance"/>
<PropertyRef Name="Timestamp"/>
</Key>
<Property Name="Timestamp" Type="Edm.DateTimeOffset"/>
<Property Name="Instance" Type="Edm.String"/>
<Property Name="ip" Type="Edm.String"/>
<Property Name="port" Type="Edm.Int32"/>
<Property Name="data" Type="Edm.Int32"/>
</EntityType>
<Function Name="GetData" EntitySetPath="is_reporting/is_reportingData" IsBound="true" IsComposable="true">
<Parameter Name="is_reporting" Type="IVserver.odatasrv.is_reporting"/>
<Parameter Name="From" Type="Edm.DateTimeOffset" Nullable="false"/>
<Parameter Name="To" Type="Edm.DateTimeOffset" Nullable="false"/>
<ReturnType Type="Collection(IVserver.odatasrv.is_reportingData)" Nullable="false"/>
</Function>
<EntityContainer Name="Container">
<EntitySet Name="is_reporting" EntityType="IVserver.odatasrv.is_reporting"/>
<EntitySet Name="is_reportingData" EntityType="IVserver.odatasrv.is_reportingData" IncludeInServiceDocument="false"/>
</EntityContainer>
</Schema>
</edmx:DataServices>
