Forum Discussion

wonga's avatar
wonga
Continued Contributor
10 years ago

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...
Need Help
arify's avatar
arify
Microsoft Employee
10 years ago

Hi wbsissonii,

 

Please make sure you installed the latest version (that got released a few days ago) and then do this workaround:

 

Go to Get Data > Blank Query > (In the query editor) Advanced Editor > Paste this:

let
    Source =  Odbc.DataSource("dsn=YOURDSN", [HierarchicalNavigation=false])
in
    Source

Please let me know how it went.

 

Thanks

wbsissonii's avatar
wbsissonii
Frequent Visitor
10 years ago

arifyI added the code in the Advanced Editor.  It now brings up the hierarchy from the subject area for the tables but does not include the columns.  So:

 

I see the Subject Area that I'm expexting and all of the tables and indented tables but no columns to select data from.  

 

Ex:

 

SubjectAreaGlobal

-SubAreaGlobalPerson

--TableDimensionPerson

--TableDimensionMeasurementType

--TableDimensionMeasurementDates

--FactMeasurements

 

I would expect to see columns to select from beneath each of the tables (--) such as PersonID, PersonName, MearuementType, MearuementDate, etc....

 

The query editor recongizes this because it has indentifed each of the areas as Data Type = Table and ABC Kind = Table.

 

 

If I click on the table hyperlink for the row of the table I get mixed results:

 

I click on one of the dimensions (measurement) and I see the data from the table of the underlying database.  

 

I click on the dimension for Person and I get an error message:

 

DataSource.Error: ODBC: ERROR [HY000] [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

ERROR [HY000] [nQSError: 43113] Message returned from OBIS.

ERROR [HY000] [nQSError: 43119] Query Failed:

ERROR [HY000] [nQSError: 17001] Oracle Error code: 904, message: ORA-00904: "T944"."CHILDLMISPLITMEASURETYPE": invalid identifier
at OCI call OCIStmtExecute.

ERROR [HY000] [nQSError: 17010] SQL statement preparation failed.

 

I click on one of the Fact tables and it actually interpreted my aggreation for me and returned the appropriate response.

 

The solution appaers to be working but I have some additional research to do.  Will the fix be in future reelase so that we can import the models through the ODBC?

 

Thanks