Using OData many to many associations in Power BI

2
Hi,   I've managed to create charts in Power BI using OData from a Mendix app, but only when representing associations as associated object id's (which makes sense to me). However, if I want to use many-to-many associations, it's only possible to expose them if the associations are represented as links. I haven't figured out how to relate the objects (like this) in Power BI. Has anyone been able to achieve this?   Many thanks   Gonçalo
asked
2 answers
1

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.

https://forum.mendix.com/link/questions/8618

https://forum.mendix.com/link/questions/88818

https://forum.mendix.com/link/questions/95322

Best regards

 

 

answered
-2

Hi Goncalo,

This issue was fixed in 7.21.0:

https://docs.mendix.com/releasenotes/studio-pro/7.21

This should allow you to expose many-to-many associations.


Regards ​​​​​​​

answered