Forum Discussion
Not able to connect to Oracle Database. please help
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.
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.4)
- 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
2 Replies
- chandraFrequent Visitor
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.
-
- v-caliao-msftMicrosoft Employee
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.4)
- 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