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

We're working on handling a driver bug, this 'could' be one of those bugs we don't handle yet.

 

Can you open Advanced Query window, and in the M code you see, you'll see something like HierarchicalNavigation=true. Can you set it to false and try again?

wonga's avatar
wonga
Continued Contributor
10 years ago

arify, this is the error I get when implementing your suggested change:

 

 

Thanks.

 

EDIT: In reference to your follow up question, I believe the ODBC connector is configured to connect to an Oracle BI Application Server and NOT an Oracle Database.

  • arify's avatar
    arify
    Microsoft Employee
    10 years ago

    This is a new issue, I haven't seen this before. Can you help us fix this?

     

    Can you send us a frown, including your

    • M query when HierarchicalNavigation=false,
    • PowerBI desktop traces (Options > Diagnostics > Enable tracing and then reproduce this failure. Then, get those files that appeared in the Traces folder)
    • ODBC traces

    Thanks!

    • wonga's avatar
      wonga
      Continued Contributor
      10 years ago

      Hi arify, I sent the requested information earlier today. Is there any way you can confirm receipt of my error submission?

      • arify's avatar
        arify
        Microsoft Employee
        10 years ago

        We got your email, thanks :)

         

        Actually, when you set the HierarchicalNavigation to false, can you also remove the last step?

         

        So, your M query should be like this:

         

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

         

        See if that works :)