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.
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>
What is the exact error message you get when you connect to OData service with IncludeInServiceDocument set to "false"?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |