Microsoft power bi desktop 32 bit

Skip to main content This browser is no longer supported. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Connect to an Oracle database with Power BI Desktop Article08/15/2024 In this article -->You can easily connect to Oracle to access and analyze data in Power BI Desktop. This article describes the initial setup requirements for creating the connection.To connect to an Oracle database or Oracle Autonomous Database with Power BI Desktop, install Oracle Client for Microsoft Tools (OCMT) on the computer running Power BI Desktop. The OCMT 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.Supported Oracle Database versions:Oracle Database 12c (12.1.0.2) and laterOracle Autonomous Database - all versionsDetermine which version of Power BI Desktop is installedTo determine which version of Power BI Desktop is installed, on the Help ribbon, select About, then check the Version line. In the following image, a 64-bit version of Power BI Desktop is installed:OCMT installs and configures Oracle Data Provider for .NET (ODP.​NET) to support 32-bit and 64-bit Microsoft tool connections with Oracle on-premises and cloud databases, including Oracle Autonomous Database. It is a graphical installer that automates the Oracle Database Client setup process. It supports connecting with Power BI Desktop, Power BI service, Excel, SQL Server Analysis Services, SQL Server Data Tools, SQL Server Integration Services, SQL Server Reporting Services, and BizTalk Server.OCMT is free software. It can be downloaded from the Oracle Client for Microsoft Tools page and is available for 32-bit or 64-bit Power BI Desktop.Power BI Desktop uses unmanaged ODP.​NET to connect to Oracle database or Oracle Autonomous Database.You can find step-by-step instructions on how to use OCMT and set up Oracle database connectivity in Power BI Desktop here.Connect to an Oracle database with the on-premises data gatewaySome Power BI Desktop app deployments use the on-premises data gateway to connect to Oracle database. To connect to an Oracle database with the on-premises data gateway, use 64-bit OCMT on the computer running the gateway since the gateway is a 64-bit app. For more information, go to Manage your data source - Oracle.Connect to an Oracle DatabaseFor information about connecting to an Oracle database or an Oracle Autonomous database from either Power BI Desktop or the Power BI service, go to the Power Query article on Oracle databases.Related contentDirectQuery

Skip to main content This browser is no longer supported. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Oracle database Article01/24/2024 In this article -->SummaryItemDescriptionRelease StateGeneral AvailabilityProductsExcelPower BI (Semantic models)Power BI (Dataflows)Fabric (Dataflow Gen2)Power Apps (Dataflows)Dynamics 365 Customer InsightsAnalysis ServicesAuthentication Types SupportedWindows (desktop/online)Database (desktop)Basic (online) Microsoft account (desktop)Function Reference DocumentationOracle.DatabaseNoteSome capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.PrerequisitesSupported Oracle versions:Oracle Database Server 12c (12.1.0.2) and laterOracle Autonomous Database - all versionsBefore you can connect to an Oracle database using Power Query, you need to install the Oracle Client for Microsoft Tools (OCMT).To connect to an Oracle database with the on-premises data gateway, 64-bit OCMT must be installed on the computer running the gateway. For more information, go to Manage your data source - Oracle.Capabilities SupportedImportDirectQuery (Power BI semantic models)Advanced optionsCommand timeout in minutesSQL statementInclude relationship columnsNavigate using full hierarchyOracle Client for Microsoft Tools installs and configures Oracle Data Provider for .NET (ODP.NET) to support 32-bit and 64-bit Microsoft tool connections with Oracle on-premises and cloud databases, including Oracle Autonomous Database (ADB). OCMT is a graphical installer that automates the Oracle Database Client setup process. It supports connecting with Power BI Desktop, Power BI service, Fabric (Dataflow Gen2), Excel, SQL Server Analysis Services, SQL Server Data Tools, SQL Server Integration Services, SQL Server Reporting Services, and BizTalk Server.OCMT is free software. It can be downloaded from the Oracle Client for Microsoft Tools page. For 64-bit Power BI Desktop and Power BI service, use 64-bit OCMT. For 32-bit Power BI Desktop, use 32-bit OCMT.Even if you already have an Oracle Client or ODP.NET installed on your Power BI client, it's highly recommended you use the OCMT installer to properly complete all the configuration steps Power BI requires to work with Oracle database.OCMT 64-bit and 32-bit downloadsOCMT installation and setup instructionsConnect to an on-premises Oracle database from Power Query DesktopTo make the connection, take the following steps:Select the Oracle database option in the connector selection.Specify the Oracle net service name/TNS alias or Easy Connect (Plus) connection string to connect to in Server. Easy Connect is the simplest to use by setting the Server value to your Oracle Database server Hostname/ServiceName, where ServiceName is the global database name. The following screenshot uses a net service name.If you're connecting from Power BI Desktop, select either the Import or

To the c:\oracle32 folder where Microsoft Report Builder is installed.Register Managed ODP.NET:Install the Oracle "ODAC with Oracle Developer Tools for Visual Studio - OUI" (32-bit) on the Oracle download site.Register ODP.NET Managed Client to GAC:C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:gac /providerpath:C:\oracle32\product\18.0.0\client_1\odp.net\managed\common\Oracle.ManagedDataAccess.dllAdd ODP.NET Managed Client entries to machine.config:C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:config /force /product:odpm /frameworkversion:v4.0.30319 /providerpath:C:\oracle32\product\18.0.0\client_1\odp.net\managed\common\Oracle.ManagedDataAccess.dll64-bit drivers for Power BI Report BuilderNoteThe following instructions apply to Power BI Report Builder version 15.7.01678.0001 and later. For versions before 15.7.01678.0001, follow the 32-bit drivers for Microsoft Report Builder instructions.Power BI Report Builder uses Managed ODP.NET for authoring paginated (RDL) reports. You only need the following steps for Oracle ODAC drivers 12.2 and later. Otherwise, they install by default to a non-machine-wide configuration for a new Oracle home installation.Prerequisite: Install the ODAC 18.x files to the c:\oracle64 folder where Power BI Report Builder is installed.Register Managed ODP.NET:Install the Oracle 64-bit ODAC Oracle Universal Installer (OUI) on the Oracle download site.Register ODP.NET Managed Client to GAC:C:\oracle64\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:gac /providerpath:C:\oracle64\product\18.0.0\client_1\odp.net\managed\common\Oracle.ManagedDataAccess.dllAdd ODP.NET Managed Client entries to machine.config:C:\oracle64\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:config /force /product:odpm /frameworkversion:v4.0.30319 /providerpath:C:\oracle64\product\18.0.0\client_1\odp.net\managed\common\Oracle.ManagedDataAccess.dll64-bit and 32-bit drivers for Power BI DesktopPower BI Desktop uses Unmanaged ODP.NET for authoring Power BI reports. You only need the following steps for Oracle ODAC drivers 12.2 and later. Otherwise, they install by default to a non-machine-wide configuration for a new Oracle home installation.Prerequisite: Install the ODAC 18.x files to the c:\oracle64 folder for 64-bit Power BI Desktop or the c:\oracle32 folder for 32-bit Power BI Desktop.Register Unmanaged ODP.NET:64-bit Power BI DesktopInstall the Oracle 64-bit ODAC Oracle Universal Installer (OUI) on the Oracle download site.Register ODP.NET Unmanaged Client to GAC:C:\oracle64\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:gac /providerpath:C:\oracle64\product\18.0.0\client_1\odp.net\bin\4\Oracle.DataAccess.dllAdd ODP.NET Unmanaged Client entries to machine.config:C:\oracle64\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:config /force /product:odp /frameworkversion:v4.0.30319 /providerpath:C:\oracle64\product\18.0.0\client_1\odp.net\bin\4\Oracle.DataAccess.dll32-bit Power BI DesktopInstall the Oracle "ODAC with Oracle Developer Tools for Visual Studio - OUI" (32-bit) on the Oracle download site.Register ODP.NET Unmanaged Client to GAC:C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:gac /providerpath:C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\Oracle.DataAccess.dllAdd ODP.NET Unmanaged Client entries to machine.config:C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:config /force /product:odp /frameworkversion:v4.0.30319 /providerpath:C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\Oracle.DataAccess.dll Connection stringContact your database administrator for connection information and for the credentials to connect to the data source. The following connection string example specifies an Oracle database on the server named Oracle18 by using Unicode. The server name must match the definition in the Tnsnames.ora configuration file as the Oracle server instance name:Data Source="Oracle18"; Unicode="True" For more connection string examples, see Create data connection strings in Report Builder. CredentialsCredentials are required to run queries, preview the report locally, and preview the report from the report server.After you publish your report,