1. Using Oracle Client for Microsoft Tools
  2. Connecting with Microsoft Tools
  3. Microsoft Power BI Desktop

3.1 Microsoft Power BI Desktop

Configure Microsoft Power BI Desktop to connect to Oracle Database.

Microsoft Power BI Desktop uses unmanaged Oracle Data Provider for .NET (ODP.NET) for data access. You can configure Microsoft Power BI Desktop to access on-premises database and both dedicated and serverless ADB. The instructions for on-premises databases setup also apply to Oracle Database Cloud Services and Oracle Exadata Cloud Service.

Overview

The general steps to set up Oracle database connectivity with Microsoft Power BI Desktop are:

  1. Provision Oracle database or ADB.
  2. Download database credentials to Windows client. (See Database Client Configuration Files.)
  3. Install Power BI on Windows client.
  4. Install and configure ODP.NET on Windows client with OCMT. (See Installing and Configuring Oracle Client for Microsoft Tools.)
  5. Validate Power BI connects to Oracle database or ADB.

This section covers how to complete step 5, and assumes you have already completed steps 1-4. Database Client Configuration Files covers step 2. Installing and Configuring Oracle Client for Microsoft Tools covers step 4.

Parent topic: Connecting with Microsoft Tools

3.1.1 Validating Power BI Connects to Oracle DB

Validate the Power BI Desktop connection to Oracle Database by setting up the connection from Power BI Desktop.

  1. Open Power BI Desktop.
  2. On the menu bar, click Get data, More....
  3. Select Database, Oracle database, Connect.
  4. In the Server text box, enter your database net service name or an Easy Connect (Plus) string.
    If you are using a tnsnames.ora file with your Oracle database, open the file to see which ADB or database net service names you can connect to. The screenshot shows three different ones: adwptr_high, adwptr_low, and adwptr_medium. Use one of these values for the server name.
    Description of adwptr-examples.png follows
    Description of the illustration adwptr-examples.png

  5. Set any other Power BI settings needed on this screen.
  6. Click OK.
  7. Select Database and enter your database credentials.
    Note: Oracle Autonomous Database Serverless, new Oracle Database 19c release updates, and Oracle Database 23c support Microsoft Entra ID/Azure Active Directory connections.
  8. Click Connect.
  9. To continue, select the schema objects needed for your Microsoft Power BI Desktop file (.pbix) and load the data.
Congratulations! Powder BI Desktop is connected to ADB or an on-premises Oracle database. For information on performance tuning for large data retrievals, see Performance Tuning for Unmanaged ODP.NET.

Parent topic: Microsoft Power BI Desktop