Can we integrate a Microsoft Power BI Online Report as a source for EPM Cloud using REST API?
We want to use data from Microsoft Projects via a Cloud report form Microsoft Power BI to feed into our Essbase Cube. Naturally we'd expect to load this data through Data Exchange/Management.
It's worth noting that since this is a Cloud Power BI instance, there is no accessible SQL database, but it can provide data using an OData feed.
Is there any way to leverage the integration agent or any groovy business rule logic to pull that feed directly into the workbench? My instinct is to attempt to run a REST API call from a Groovy rule but I welcome any thoughts from those that have tried this use case or have done something similar!