Cannot list Oracle table RRS feed

  • Question

  • I am trying to retrieve a table from an Oracle server. When I connect to the server with PowerQuery, I get the full list of tables. The issue is when I try to drill down to one of the tables (whatever the table, the issue remains the same). If I simply use the drill down feature, the query never returns anything, and I end up having to cancel the refresh.

    However, if I include an SQL statement in the connection, then it works.

    = Oracle.Database("myoracleserver/OAPEXP", [Query="Select * from UMD_PRDT.PRDT_AGGREGATE_SUPITEM"])

    How can I get the interactive selection of table (i.e. drill down)  work as expected?

    Note: using Oracle Database 12c Enterprise Edition Release - 64bit Production, with latest instant client drivers.

    Monday, September 28, 2015 8:32 AM