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

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

      • wonga's avatar
        wonga
        Continued Contributor
        10 years ago

        arify I've tried your suggestion and it doesn't look like it changed anything. One interesting thing to point out is that when you click on the "Source" step under "Applied Steps", it shows a list of elements from the physical layer (e.g. Oracle Data Warehouse). I'm given the option to expand a "Data" column, but the result of that is all "null" values.

        Thanks.

         

        EDIT: arify Do you know if the steps regarding exposing key fields in this page need to be done in order for an ODBC connection to the Oracle BI Server?

         

        http://kb.tableau.com/articles/knowledgebase/tableau-and-obiee