I'm using MS Office 2013 32 bit version. Have the Power query Plug-in enabled. I have Oracle client installed and have 2 Oracle homes in my machine (Windows 10 enterprise 64-bit). Now I tried to install the ODAC 32-bit but the command prompt collapses before I can see any error.
Then while trying the Excel Power query > Oracle Database I receive an error that: Recommended provider (ODAC) is not installed. You can continue with your current provider.. etc.
And while using the TNS defined I get the error message: TNS could not resolve the connect identifier.
Besides, I have added one Oracle home in "path" and TNS file location in "TNS_ADMIN" environment variables.
Please suggest what can I do to resolve this.
