1. Connecting Oracle Analytics Cloud to Your Data
  2. Connecting to Oracle Analytics Cloud From Other Applications
  3. Connect to Oracle Analytics Cloud from Microsoft Power BI (Preview)
  4. Configure a Microsoft Power BI Environment for Oracle Analytics Cloud Integration (Preview)

Configure a Microsoft Power BI Environment for Oracle Analytics Cloud Integration (Preview)

Configure your environment to integrate Microsoft Power BI Desktop with Oracle Analytics Cloud so that you can analyze data from Oracle Analytics Cloud.

Before you start, use the Oracle Analytics Model Administration Tool to create a data model in Oracle Analytics Cloud so that you can access the subject areas and tables in the presentation layer.
  1. Install Microsoft Power BI Desktop.
    Install the minimum required version. See Prerequisites for Microsoft Power BI Integration (Preview).
    After you've installed it, configure these settings:
    1. In Power BI Desktop, navigate to Options and Settings.
    2. Under GLOBAL click Security, then under Data Extensions, select (Not Recommended) Allow any extension to load without validation or warning.
    3. Under GLOBAL, click Data Load, and set the value of Maximum memory used per simultaneous evaluation (MB) based on the available memory on your machine.
      Tip: To see how much memory your machine has available, hover over the information (i) icon next to Maximum memory used per simultaneous evaluation (MB).
      Description of power-bi-memory-setting.png follows
      Description of the illustration power-bi-memory-setting.png
    4. Under CURRENT FILE, click Data Load, and select Enable parallel loading of tables.
  2. Install Oracle Analytics Client Tools in the same environment as Microsoft Power BI Desktop.
    1. Navigate to:
    2. Click Oracle Analytics Client Tools <Month Year> Update to display the Oracle Software Delivery Cloud page, and select the latest version.
    3. Click the Platforms down arrow, click Microsoft Windows x64 (64-bit), then click outside of the drop-down list or press Enter.
    4. In the Software column of the table, make sure that Oracle Analytics Client... is selected, and de-select other ZIP files (for example, Windows Data Gateway...).
    5. Accept the Oracle Cloud Service License Agreement.
    6. Click Download to start Oracle Download Manager, and follow the on-screen instructions.
    7. Unzip the ZIP file that you downloaded to extract the installer file setup_bi_client-<update ID>-win64.exe.
    8. Double-click the file setup_bi_client-<update ID>-win64.exe to start the installer.
    9. Follow the on-screen instructions.
  3. In the same environment, download and install the Power BI connector for Oracle Analytics Cloud.
    1. Navigate to:
    2. Click the download link for Oracle Analytics Cloud Connector for Microsoft Power BI to display the Oracle Software Delivery Cloud page, and select the latest version.
    3. Click the Platforms down arrow, click Microsoft Windows x64 (64-bit), then click outside of the drop-down list or press Enter.
    4. In the Software column of the table, make sure that Oracle Analytics Power BI Connector... is selected, and de-select other ZIP files (for example, Windows Data Gateway...).
    5. Accept the Oracle Cloud Service License Agreement.
    6. Click Download to start Oracle Download Manager, and follow the on-screen instructions.
    7. On your local machine, create a \Power BI Desktop\Custom Connectors folder in C:\Users\<username>\Documents\.
      For example, C:\Users\<username>\Documents\Power BI Desktop\Custom Connectors.
    8. Copy the downloaded OracleAnalyticsCloud-x.x.x.mez into the \Power BI Desktop\Custom Connectors folder.
    9. Start or restart Microsoft Power BI Desktop.