![]() In the Telecom and IT area for example, numerous elements, alarms, meters and gauges, complaints and service calls, customer data and various other variables need to be stored properly so they can later be processed to extract results as analyses and reports. And in any area where there’s this need for data usage, there will also be a form of storage and control thereof, such as large databases. The trend is that this growth will increase more and more. 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.There’s no doubt the use of data nowadays is much bigger than just a little while ago. 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. 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. 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 |