![]() 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. Oracle Data Access Client (ODAC) software 11.2 or greaterīefore you can connect to an Oracle database using Power BI, you need to install the Oracle Data Access Client (ODAC) software 11.2 or greater on your computer.It also depends on your version of Oracle server. Subscription trials require internet access and are only available in a 64-bit version. To install the 32-bit ODAC software, go to 32-bit Oracle Data Access Components (12.1.0.2.4) or choose a version you prefer. Download Toad for Oracle Subscription will download after you complete the form This Toad for Oracle Subscription trial grants a 30-day trial of Toad for Oracle DBA Plus - to learn more about what is in each subscription - check out our product matrix. To install the 64-bit ODAC software, go to 64-bit Oracle Data Access Components (12.1.0.2.4) or choose a version you prefer. You must choose a Windows Installer version since x-copy version doesn't work with Power BI Desktop. "Machine-wide configuration is no longer supported beginning with ODAC 18c. ![]() Once Oracle 18.x/19.x is installed the customer must follow the instructions here: Registering Oracle drivers for Power BI Desktop Administrators can still place ODP.NET in the GAC and add the configuration section handler and DbProviderFactory information to nfig manually if they wish to override ODP.NET settings for individual applications." ![]() If you're configuring an Oracle database for Power BI Desktop, On Premises Data Gateway, or Power BI Report Server, consult the information in the Oracle Connection Type article. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |