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

3.2 Microsoft Power BI Service

Configure Microsoft Power BI Service to connect to Oracle Database.

Microsoft Power BI Service runs in the Microsoft 365 cloud. Power BI service uses an on-premises data gateway, also known as Power BI gateway, to connect the Power BI service to Oracle databases. The gateway is hosted on Windows, either on-premises or in a cloud virtual machine, such as in Oracle Cloud Infrastructure or Azure.

These instructions use 64-bit unmanaged Oracle Data Provider for .NET (ODP.NET) for data access. They work for 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

These are the general steps to setup Oracle database connectivity with Microsoft Power BI Desktop:

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

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

Parent topic: Connecting with Microsoft Tools

3.2.1 Installing and Configuring Power BI Gateway

Download Power BI Gateway from the Power BI website.

To install and configure Power BI Gateway:

  1. Sign on to the Power BI website with your Microsoft 365 account.
  2. From the Power BI web console, click Menu, Download, Data Gateway.
  3. Click Download standard mode.
  4. After the gateway installation file downloads, run GatewayInstall.exe.
  5. Select the installation directory location, and accept the terms.
  6. Complete your registration of the Power BI gateway:
    1. Enter the email address of your Power BI service account.
    2. Sign in.
    3. Select Register a new gateway on this computer.
    4. Click Next.
    5. Name the gateway, provide the recovery key, and confirm the key.
      You use the gateway name when creating a Power BI Data Source.
    6. Click Configure.
The gateway is now online and ready to use.
Description of powerbiservicegatewayonline.png follows
Description of the illustration powerbiservicegatewayonline.png

Parent topic: Microsoft Power BI Service

3.2.2 Validating Power BI Connects to Oracle DB

Configure and validate the Power BI Service connection to Oracle Database.

  1. Log into the Power BI website with your Microsoft 365 account.
  2. Navigate to a Power BI Premium or Power BI Pro workspace.
  3. Click New, Dataflow.
  4. On the Start creating your dataflow screen, select Add new tables.
  5. Select Oracle database.
  6. Provide the entries to connect to your data source:
    1. Server - Enter the database net service name.
      For example, adwptr_high, adwptr_low, or the Easy Connect (Plus) configuration.
      For more information, see Setting Up On-Premises Databases.
    2. Data gateway - the Power BI gateway name.
    3. Authentication kind - Basic
    4. Username and Password - Your ADB or on-premises database user credentials
  7. Click Next to complete the connection.
  8. To continue, select the schema objects needed for your Microsoft Power BI application and load the data.
Congratulations! Power BI Service now connects to Oracle Database. You can now view the schema objects by selecting the objects from the tree control. For information on performance tuning for large data retrievals, see Performance Tuning for Unmanaged ODP.NET.

Parent topic: Microsoft Power BI Service