You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can we integrate a Microsoft Power BI Online Report as a source for EPM Cloud using REST API?

edited May 4, 2023 11:24AM in Planning

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!

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!