Recommended driver package for Oracle connection: mandatory?

[Anonymous]

Hi, I have a situation in a company where Oracle drivers (sometimes 32 bits, sometimes 64 bits) are (sometimes) installed on W10 and W7 laptops belonging to content creators using Power BI Desktop.

The documentation recommends installing a specific package to connect to Oracle database from Power BI Desktop. Is that mandatory or can my users do without it and use the drivers already installed on their PCs?

Documentation: https://docs.microsoft.com/fr-fr/power-bi/desktop-connect-oracle-database

[v-xicai · Accepted solution]

Hi @Anonymous ,

Currently, it is not supported to connect to Oracle in Power BI directly, you need to install the recommended Oracle client first of all.

• For32-bit versions of Power BI Desktop: 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2....
• For64-bit versions of Power BI Desktop: 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64

While there is an idea about this issue, please vote it up, https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32002366-oracle-connection , to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.

Best Regards,

Amy

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

[UAV-Test-Pilot]

Can I piggy back off of this thread... 

Are you saying the only  version of the Oracle files that PowerBI supports is 12.1.0.2.4 regardless of which version of Oracle my organization actually runs?

I tried installing the files for my Oracle version but I'm still getting the depracated warning:

"Oracle database

The recommended provider ('Oracle.DataAccess.Client') is not installed. You can continue with your current provider, however it has been depracated and may not work correctly."