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
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 :)

      • arify's avatar
        arify
        Microsoft Employee
        10 years ago

        wonga I also noticed this:

         

        let
            Source = Odbc.DataSource("dsn=#YOURDSNNAME#", [HierarchicalNavigation=true]),
            #"Procurement and Spend - Purchase Orders#(#)(0000)_Database" = Source{[Name="Procurement and Spend - Purchase Orders#(0000)",Kind="Database"]}[Data]
        in
            #"Procurement and Spend - Purchase Orders#(#)(0000)_Database";

         

        Looks like we're picking a null character at the end of the database name. From your M query (where HierarchicalNavigation is still set to true) can you remove the #(0000) I striked above?

         

        Note: the code I'm pasting here is incomplete, because of a forum bug it swallows rest of the code after a closing curly bracket character. So, instead of copying this code, change your existing code :)