none
Error when trying to connect to an Oracle Database RRS feed

  • Question

  • I am using the Excel Power Query Addin.

    I am trying to connect to an Oracle Database and I get the following error

    Unable to connect

    We encountered an error while trying to connect

    Details: "Object reference not set to an instance of an object."

    I sent a frown on Tuesday and have not heard anything back.

    Can anyone please help?

    I have been stuck on this for a week.

    Friday, June 10, 2016 8:30 AM

Answers

  • In order to connect to an Oracle database with power query, you need an additional piece of software: Oracle Basic Instant Client for Microsoft Windows.
    Did you complete the installation of this driver?
    See details here:
    https://support.office.com/en-us/article/Connect-to-an-Oracle-database-Power-Query-d7fbd231-a705-4eb7-83b3-a66bfb678395
    Friday, June 10, 2016 11:56 AM