Question

Publish rest service IDs

0

I want to analyse data in a Mendix app with Power BI or Excel. Easy way would be OData but.... with the current Mendix OData implementation *:* relations won't work and I cannot relate entities in Power-BI. I try to do this with Rest service but I don’t get the ID's I need in Power-bi to relate tables Is there a way to achieve this?

asked 2018-10-27

Arthur van der Molen

1 answers

Pim van der Noll · Answer 1 · 2018-10-29

I managed *-* relations by replacing them with a new entity and add 1-* associations between the original entities (and create a conversion flow for the existing data 🔀) and use Odata in combination of Power BI (Power BI is capable of analysing assocications and create relations based on the data, Excel not..) .

I like the idea of publishing a REST API that should work. Maybe you can use the java action to getGUID for getting the ID's on demand of a record (not the fastest option I think in case of high volumes). Let us know if this is working out for you in some way 😬!