I want to expose my accounts and companies to PowerBI with OData, but OData has its limitations.
OData services have a option to publish many to many associtions as links since 7.21. This link looks like this https://app.mendixcloud.com/odata/app/parties(22799473113563137)/Accounts.
This is not a table with a account id and party id. We can use these links in Azure if we write custom logic in Azure, but we don't want that, so we are going to stick to the solution in 8618 going to create a account – party entity.
@Mendix I dont like your solution for idea 564 and would like to expose a many to many association as an association table.
This issue was fixed in 7.21.0:
This should allow you to expose many-to-many associations.