Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Does anyone know if I can connect to an Oracle Essbase Database?
Thank you,
Joseph
I took a lot of time searching on the web and did not found any solution 😞
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
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
@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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.