Forum Discussion
Power Query to Oracle using OLE DB not working
I am trying to get Power Query (Excel) to Oracle 12c working. In excel using ODBC and MS Query I can connect to Oracle fine. You cannot use ODBC with Power Query you have to use Microsoft OLE DB for ...
Hi danny-uk ,
Did you mean you could see and use other tables except Users table? Do you have access to it in Oracle database?
Please provide more details.
Best Regards,
Eyelyn Qin
Hi Eyelyn
I have a username and password, the ip address and database name. When connecting with the Data Link wizard using OLD DB I put Data Source as ipaddress/database name, then put the user and password in. The wizard then displays tables that are not the tables in ipaddress/database that was specified. I am assuming it is an Oracle system database as some of the tables are like OPS$Username.
Regards
Danny