Odata being loaded into PowerBi not being able to create relationships declared in $metaData
0
we are trying to connect to powerBi via oData. If i look at the metadata file: I can see that there are navigation properties exposed that show the relationships <EntityType Name="SheetRequest"> <Key> <PropertyRef Name="UUID"/> </Key> <Property MaxLength="200" Name="Name" Type="Edm.String"/> <NavigationProperty Name="TransactionRequestsFROM" Partner="SheetRequestFROM" Type="Collection(DefaultNamespace.TransactionRequest)"/> <NavigationProperty Name="TransactionRequestsTO" Partner="SheetRequestTO" Type="Collection(DefaultNamespace.TransactionRequest)"/> </EntityType> This is a 'join table/ elbow joint' when i open the data in power bi we get the following: when i transform the data: I can see the ' links/navigation' that are referencing another table. how do i get PowerBi to connect to connect the tables?