Help with: Connecting Oracle Database to Power-BI Report Server desktop

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