Get Data >Oracle DB: getting "Recommended provider is not installed" warning even after installation

[I_NeedMorePower]

Hello power people! 

I want to get the data from an oracle DB, but once I choose it, I get this warning message:

"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 click on "Learn more" hyperlink which led me to this document page:

https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database#installing-the-oracle-clie...

I followed the instructions on this page and I installed the latest oracle ODAC package on my machine.

After installation was complete I went back to Power BI and clicked on "Get Data > Oracle DB" but I still get the same warning.

The package I installed: 64-bit ODAC 12.2c Release 1 (12.2.0.1.1) for Windows x64

NOTE*: I installed the ODAC package on my "D" drive part while the Power BI is installed on the "E" drive part. Is this what is causing the issue?

What should I do in order to have the recommended provider?

Thanks in advance!

[v-yuta-msft]

@I_NeedMorePower ,

Please check if the bit version of ODAC matched power bi desktop.

For 32-bit versions of Power BI Desktop, use the following link to download and install the 32-bit Oracle client:

• 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2....

For 64-bit versions of Power BI Desktop, use the following link to download and install the 64-bit Oracle client:

• 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[I_NeedMorePower]

Thanks for your reply v-yuta-msft,

I did install the 64 bit. The power bi and my machine are 64 bit too.

So I don't think it's the case...

[eeurton]

Did  you ever resolve this issue? I am having the same problem.

[I_NeedMorePower]

Hi eeurton,
Unfortunately no, I couldn't find a fix 😞
I just used another device which did not have this problem.