Unable to Connect - Oracle

[Anonymous]

I am using Win10 Pro.   After upgrading to the latest 64-bit PBI client (Version: 2.86.902.0 64-bit (October 2020), our connection to the Oracle database server now reports:

All worked fine previously.   We've tried all of the recommendations found in the 'Learn More' link and continue to get this error.     Any recommendations?

[v-alq-msft]

Hi, @Anonymous 

To connect to an Oracle database with Power BI Desktop, the correct Oracle client software must be installed on the computer running Power BI Desktop. The Oracle client software you use depends on which version of Power BI Desktop you've installed: 32-bit or 64-bit. It also depends on your version of Oracle server.

Note:

'Choose a version of Oracle Data Access Client (ODAC) which is compatible with your Oracle Server. For instance, ODAC 12.x does not always support Oracle Server version 9. Choose the Windows installer of the Oracle Client. During the setup of the Oracle client, make sure you enable Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level by selecting the corresponding checkbox during the setup wizard. Some versions of the Oracle client wizard selects the checkbox by default, others do not. Make sure that checkbox is selected so that Power BI can connect to your Oracle database.'

Here are supported Oracle versions:

• Oracle Server 9 and later
• Oracle Data Access Client (ODAC) software 11.2 and later

For further information, please refer to the following document.

 Connect to an Oracle database with Power BI Desktop 

Best Regards

Allan

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