Forum Discussion

vakshi's avatar
vakshi
Frequent Visitor
9 years ago
Solved

Oracle connection error

Hi all,   I'm getting this error message when trying to get data from oracle DB. the error message appears when I choose "Oracle", Before choosing the relevant DB and user/password:   "The recom...
rick_macleod204's avatar
rick_macleod204
Regular Visitor
7 years ago

doesn't matter how many times i try to install / uninstall ...change drivers ... install Just ODAC via

install.bat all c:\oracle odac

... I cannot get Power BI to Connect to Oracle DB. ...everything else works  fine. 

 

I have both the 32bit and 64bit oracle drivers installed (32 needed for other applications) - Is Power BI getting confused as to where the correct driver is - is there an optimal order of environment variables to get Power BI to recognize the correct driver - ALL other applications on my workstation connect without issue - however Power BI is the only one attempting to connect via ODAC . 

 

Is there any resolution to this error ....OTHER than the very uninformative solution provided? 

UAV-Test-Pilot's avatar
UAV-Test-Pilot
Helper II
6 years ago

Rick, not sure if you are still having this issue, but all microsoft products will use ODAC

 

Steps I got it to work 

 

1) Match your "driver" to your application bit type. So if you downloaded PowerBI 32 bit you need to install 32 bit ODAC driver

2) Only install the 12.2 files regardless of which Oracle you have on premesis

3) I reccomend using the XCOPY files, for some reason the GUI installer worked only half the time

4) XCOPY instrucstions are included inside the ZIP, but heres an abridged version

... a) unzip to C:\

... b) open CMD as ADMINISTRATOR (don't forget this step)

... c) naviagate to unzipped folder inside CMD (type in "CD C:\[insert your folder name here]")

... d) type in "install_odpm.bat C:\Oracle"

 

If you want all the options the installer can do, just type in "install_odpm.bat" and it will show you the options

 

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-manage-oracle