Forum Discussion
Custom data connector - relationships
bastiaaf,
Have you checked the sample in the blog below? Power Query code about defining relationships has been provided in the blog.
https://github.com/Microsoft/DataConnectors/tree/master/samples/Relationships
Regards,
Lydia
Anonymous, I did, but either I don't get the example or it's not meant for what I want to do...
Currently this is the result:
With this piece of code:
#"CompanyLocation" = Table.NestedJoin(#"Companies",{"ID"},OTGConnector.GetLocations(),{"Company.Id"},"CompanyLocations",JoinKind.LeftOuter),
#"CompanyLocationExpanded" = Table.ExpandTableColumn(#"CompanyLocation","CompanyLocations", {"Company.Id"})
So <Companies> is extended with the "Company.Id" attribute of <Locations>.
However what I want to achieve is the actual relationship in the model:
Currently, I have to explain my users to go to a menu-item and "autodetect" the relationships, which seems to be hard for them.
Would be great if I can simply code what the relationship should be...
We're facing a similar challenge.
You should follow this topic on the github repo as well...
https://github.com/Microsoft/DataConnectors/issues/150
It looks like more work around relationships is in progress.
