Reply
Frequent Visitor
Posts: 2
Registered: ‎09-21-2016
Accepted Solution

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 recommended provider ('Oracle.DataAccess.Client') is not installed. You can continue with your current provider, however it has been deprecated and may not work properly."

 

I'm using oracle client version 10.2.0.3.0, 32 bit. works fine with other apps like "Toad for oracle", plsql dev ...

Power BI desktop version 2.38.4491.282 32-bit - Aug16.

Other users also encounter the same problem.

 

any ideas how to fix this problem?

 

Thanks

Vakshi


Accepted Solutions
Super Contributor
Posts: 3,838
Registered: ‎07-08-2016

Re: Oracle connection error

@vakshi

 

You need to install the recommended provider which can be found in following links.

 

 

Please take a look at this document, it should be helpful to you.

 

Best Regards,

Herbert

View solution in original post


All Replies
Super Contributor
Posts: 878
Registered: ‎06-09-2016

Re: Oracle connection error

Please see this blog post to trouleshoot the problem.

 

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

 

You need to install 32 bit version of 

 

for connection purposes. 

More information is on the blog post.

 

 

Thanks & Regards,

Bhavesh

Super Contributor
Posts: 3,838
Registered: ‎07-08-2016

Re: Oracle connection error

@vakshi

 

You need to install the recommended provider which can be found in following links.

 

 

Please take a look at this document, it should be helpful to you.

 

Best Regards,

Herbert

New Member
Posts: 1
Registered: ‎03-27-2017

Re: Oracle connection error

I am getting a message that for ODAC 12c Release 4 (12.1.0.2) installer we need Visual Studio. Which version of visual studio should we use? I tried the community version, and I still keep getting the same message.

Frequent Visitor
Posts: 2
Registered: ‎04-11-2017

Re: Oracle connection error

Hi, you might be downloading and using the wrong connector, I had the same issue this week. 

Try creating a tnsnames.ora file in the client-> clientsname-> oracle version->client_1->Network->Admin directory 

Or use the ODCA wizard to create one: 

http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html 

 

If you prompted to install VS, that means you ahve installed the wrong connector from Oracle. 

Maybe this will work for you as well. 

 

I have written a post about my expirience: 

http://www.yanaberkovich.com/Blog/connecting-powerbi-desktop-to-oracle/ 

Frequent Visitor
Posts: 2
Registered: ‎04-19-2017

Re: Oracle connection error

[ Edited ]

For my experience, I installed on a 32-bit system and one on a 64-bit system. It's the same install on each except you must use the matching bit version of the Oracle products that matches the PowerBI Desktop bit version.

 

In my case I installed the following Oracle Client on my respective installs:

32-bit  win32_12201_client.zip

64-bit winx64_12201_client.zip

both can be found at the link below:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-windows-3633015.ht...

Note: in my case I change the default path of the install to C:\app\Oracle\product\12.2.0\client_1 but it doesn't matter where you put it.

 

After installing the client I had to install the following: (IT WILL NOT WORK WITHOUT THIS!)

32-bit ODAC121021Xcopy_32bit.zip 

http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html

64-bit ODAC121024_x64.zip 

http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

 

To install the above you must open a Administator Command Prompt and change to the path that you extracted the files to. Then run this command:

install all C:\app\Oracle\product\12.2.0\client_1 odac (the path is where you installed the above client to)

 

you also need to make sure the following is included in the 'path' of the Environment Variables:

C:\app\Oracle\product\12.2.0\client_1;C:\app\Oracle\product\12.2.0\client_1\bin (or wherever your path is loacted)

 

You need to have a TNS_ADMIN entry in the Environment Variables that points to the directory that the tns_names.ora file lives.

 

This all worked for me and hope it helps you as well.