Hi,
I have struggled with a simple issue for days now. I need to connect to an Oracle Database and retreive data from there, but I cant make it work. I have followed the steps in the following microsoft link: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database
My Power-BI report server desktop is 64-bit version which is in line with my computer.
I have downloaded both 32- and 64-bit ODAC 122011 (Not the Xcopy version) and saved them in different directories. I have also tried an earlier version of both 32- and 64-bit ODAC 121024.
- I always tick the box of Machine Wide configuration in the installation of the ODAC
- I always run the installation as administrator
- I even unpackaged the .zip file in temp to isolate the file from onedrive connection
- I have all the TNS information and access in order to connect to the database (I can connect it through oracle developer).
* I always untick the "Oracle Developer Tools for Visual Studio" in the installation of the 32-bit ODAC versions - because i cannot install the ODAC with this ticked due to the fact that I dont have visual studio installed.
Despite this, I always get the messege from Power-BI that I have not installed the Oracle client once I try to retreive data from an Oracle Database. Am I doing something wrong or am I missing anything? Do I need visual studio to just connect to an oracle DB?
Best,
Hweb
