Forum Discussion
Connect to OBIEE RPD using ODBC Connection
Are you seeing an error? Can you provide more details?
Hi arify, no error pops up but please see picture below:
As you can see, I'm trying to expand the "Purchase Orders" subject area but nothing shows up below it implying that the subject area is empty or something. Of course this isn't the case, so it looks like Power BI isn't digging deep enough or something in regards to accessing the RPD through an ODBC connection.
Also notice that the "Load" button is greyed out, implying that there is nothing to load. I can force it to load by right clicking the subject area and clicking "Load", but the end result is an import of a table with no data in it at all, as seen in the below picture:
Expanding the "Data" column results in nothing to expand to, which further implies that there is no data in the subject area from Power BI's point of view.
Thanks.
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?
Another question, are you connecting to a normal Oracle database, or is this a different datasource?
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.
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!