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.
Somebody knows how to connect an Oracle Olap DatabaBase or Oracle Cube
Hi! I am currently assesing the same thing. Oracle OLAP cube connector to Power BI. Found this link interesting https://support.biconnector.com/support/solutions/articles/8000048783-connect-power-bi-desktop-to-ob...
That again I found at Tableau https://community.tableau.com/docs/DOC-9857. Looks like they are recomending that connector for Tableau. And it looks like it can conncet directly to Oracle reports which is what I want to do.
This thread is relevant too: http://community.powerbi.com/t5/Desktop/Connect-to-OBIEE-RPD-using-ODBC-Connection/td-p/33008 Was able to connect by using Blank Query and pasting the info below, and fist setting up ODBC connection in Windows (https://gerardnico.com/dat/obiee/obis/odbc_driver_bi_server_create). Also I put a setting to the Presentation layer in Oracle Administration Tool to Export logical keys.
let
Source = Odbc.DataSource("dsn=MYDSN", [HierarchicalNavigation=false])
in
Source
Oracle offers Essbase for customers without the Oracle Database or who require multiple data-sources to load their cubes.
We've 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
Hi @mrbajana,
There is no built-in connector for Oracle OLAP or cube in Power BI Desktop. As a workaround, you can connect to Oracle OLAP in Excel using Simba MDX OLE-DB Provider, then connect to the Excel file via “File->Import->Excel workbook contents” in Power BI Desktop.
For more details about connecting to Oracle OLAP in Excel using Simba MDX OLE-DB Provider, please review the following articles.
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/bidw/olap11g_excel/olap_exc...
https://www.rittmanmead.com/blog/2010/08/oracle-olap-11g-reporting-in-excel-using-simba-mdx-ole-db-p...
Thanks,
Lydia Zhang
Thanks a lot Lydia for your Answer.
Marco
How do I connect to Oracle DataWareHouse or Cubes in Power BI??
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.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |