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
anitaberg's avatar
anitaberg
Helper I
8 years ago

Hi! Did anyone manage to get this working. Using Oracle BI Server ODBC connection and then displaying the tables after expanding a subject area?

 

I have installed a complete Oracle OBIEE test environment on my PC. The last step is to get this to work. The workaround

 

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

 

is not a good workaround in a self service perspective, the main goal would be for user to see available subject areas and then see the available tables to connect to.

 

 

  • alexrz's avatar
    alexrz
    Regular Visitor
    8 years ago

    I anm trying to run that script from Advanced Options => SQL Statement:

     

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

     

    But receive Unable to Connect error: Details: "ODBC: ERROR [HY000] [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
    [nQSError: 43113] Message returned from OBIS.
    [nQSError: 27002] Near <Source>: Syntax error [nQSError: 26012] .
    "

    Please advise

    • anitaberg's avatar
      anitaberg
      Helper I
      8 years ago

      Hi! I spent a lot of time struggling to get everything around Oracle to work. One thing that was not obvious was that Microsoft for example did not like the syntax of tnsnames.ora file, It wanted the syntax there exactly as in example on microsoft documentation.

       

      Also I made sure I tested user access and roles in SQL Developer before using it i Power BI.

      • alexrz's avatar
        alexrz
        Regular Visitor
        8 years ago

        Thank you to your responce: but I have all the necessary connections and roles. I added this script trying to fix the problem that is the main subject all this long discussion: When I open OBIEE RPD in PowerBI - I cannot drill off a Subject Level. I can use Select query as a data source & Power BI  run it (i.e it finds all the necessary tables & columns from the physical Model) , but when open RPD itself I cannot click and expand any subject area.

        This topic is discussed and somebody earlier  suggested to add script

         

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

         

         to the Advanced Connection: I added it to the SQL Box of Advane Option and got connection error. So my question was : Have I added it to the proper place and if so - what may be wrong?

        Appreciate any help