Forum Discussion
wonga
10 years agoContinued Contributor
Connect to OBIEE RPD using ODBC Connection
I'm trying to connect to the repository for OBIEE using an ODBC connection and the list of subject areas appears to load in Power BI, but I am unable to load any data into Power BI in order to make v...
wbsissonii
10 years agoFrequent Visitor
Was there ever a resolution for this (I'm experiencing the same issue). A bit of history:
- Been working with Oracle OBIEE for about 8 years and are looking at additional/alternative reporting tools but don't want to give up all of the Business Models that we have created in OBIEE
- Testing Tableau and Microsfot Power BI Desktop as alternatives that could then translate to long term solutions
- Setup a OBIEE ODBC connection that connects to OBIEE and dislays a list of Presentation Layer Subject Areas
- Setup a data source in Tableau which then brings up a sujbect area (dsignated) with a list of all of the tables and data objects within the subject area, which I can select into a report (Tableau workins using the ODBC connection)
- In Power BI I select Get Data and then select Other and then ODBC as my data source. I select the same ODBC connection for Power BI that I did for Tableau. It brings up a list of the OBIEE Subject areas but when I click to expand the list to get to the table and data elements no items are displayed. I would have expect a list of subject area tables and then subject area columns (data elements) to be selected to be displayed.
I would include screen shots but they would be indentical to other screen shots in the discussion forum. Please advise how and if there is a solution for this issue. Because we have 8 years of OBIEE data modeling it is important for us to find a way to leverage those models going forward. We would also consider a tool that could migrate those data models, the Oracle RPD, to Power BI.
Thanks...