Publish rest service IDs

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?  
1 answers

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 😬!