Not able to connect to Oracle Database. please help

[chandra]

Hi,

I have to connect to Oracle DB and my credentials are correct (SID) as I was able to connect it using another tool. When

I am trying to connect PowerBI to Oracle Database, I am finding the following problems. 

1) I tried to install the ODAC and got the following error that I need to install Visual Studio first. See screen shot #1

2) Then I downloaded Visual Studio community (is this correct application?) from visual studio website (screen shot #2)

3) when I tried to install visual studion community the installation stopped working abruptly (I troed multiple times) see screen shot #3 below. 

[v-caliao-msft · Accepted solution]

Hi @chandra,

Which version of Power BI Desktop you have installed？ You need to install 32-bit version or 64-bit version accordingly.

To determine which version of Power BI Desktop is installed, select File > About then check the Version.

• 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2....
• 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64

Reference
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-oracle-database/

Regards,

Charlie Liao

[chandra]

Hi

When I am trying to connect to ORacle DB from PowerBI, I am getting the following errors. (My oracle DB credentials are working find as I am able to connect to the DB using another tool)

1) I downloaded ODAC and tried to install it asked me install visual studio first...and getting the following error screen shot #1

2) I downloaded visual studio community (Is this correct application?). See screen shot #2

3) When I tried to install visual studiok, it aburptly stopped working (tried many times). screen shot #3

I am running an Windows 7 SP1 (Enterprise) OS.

-