Forum Discussion
Oracle OLAP
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-obiee-reports-using-direct-query-step-by-step-user-guide
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