Forum Discussion
mrbajana
9 years agoHelper III
Oracle OLAP
Somebody knows how to connect an Oracle Olap DatabaBase or Oracle Cube
Anonymous
9 years agoNot applicable
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_excel.htm
https://www.rittmanmead.com/blog/2010/08/oracle-olap-11g-reporting-in-excel-using-simba-mdx-ole-db-provider/
Thanks,
Lydia Zhang
- mrbajana9 years agoHelper III
Thanks a lot Lydia for your Answer.
Marco