Oracle Essbase Database

[joschultz]

Does anyone know if I can connect to an Oracle Essbase Database?

Thank you,

Joseph

[Spicer]

I took a lot of time searching on the web and did not found any solution 😞

[dkay84_PowerBI]

There is a solution that works, but you need to input your MDX query directly into the query editor script (i.e. as a parameter).  You also have to parameterize service ip address, port, user name and password, so it isn't really a "solution" but a temporary workaround.

http://harrygates-essbase-blog.blogspot.com/2016/09/power-query-how-to-connect-to-essbase.html

[harrygates]

I'm the author of the workaround you mentioned. We've now created a full-fledged, supported Power BI to Essbase connector: https://casabasesoftware.com/introducing-the-power-bi-casabase-connector-for-oracle-essbase/

Let us know if you're interested.

Thanks,

Harry Gates

Casabase Software

[smp0150]

@dkay84_PowerBI - Is the query editor script the m script mentioned in the link? Are you able to acces the query editor script via create blank query? Thanks!