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. Connect to Oracle Analytics Cloud from Microsoft Power BI Desktop (Preview)

Connect to Oracle Analytics Cloud from Microsoft Power BI Desktop (Preview)

Data analysts connect to Oracle Analytics Cloud from Microsoft Power BI Desktop to analyze data from Oracle Analytics Cloud subject areas.

  1. Obtain the Power BI App Key for your Oracle Analytics Cloud instance.
    In Oracle Analytics Cloud, the administrator obtains the user access key by clicking the administrator user profile, then Profile, then App Keys, and copying the Power BI App Key.
    Description of power-bi-app-key-profile.png follows
    Description of the illustration power-bi-app-key-profile.png

  2. In Microsoft Power BI Desktop, connect to Oracle Analytics Cloud.
    1. From the home page, click Get Data, locate and select Oracle Analytics (Beta) in the list of connectors, then click Connect.
    2. In the Instance URL field, paste in or specify the Power BI App Key that you obtained in Step 1.
    3. In the Logical Query (optional) field, if you've copied SQL from a workbook or report, paste in or enter the SQL code.
      Description of power-bi-3-1.png follows
      Description of the illustration power-bi-3-1.png

      Make sure that the SQL is copied from the same Oracle Analytics Cloud instance from which you obtained the Power BI App Key.
      If you haven't copied SQL code from Oracle Analytics Cloud, you can skip Step 2.c and browse to reports or subject area tables manually after you click OK.
    4. Specify advanced options (optional).
      - In Driver (optional), optionally specify an ODBC Driver Name from an Oracle Home if multiple Oracle Analytics Cloud Client Tool installations are present (the default is "Oracle Analytics").
      - In Session Variables (optional), optionally specify session variable values used in Oracle Analytics Cloud.
    5. Click OK.
      If you specified SQL code in the Logical Query field, Power BI displays the preview data.
      If you didn't specify SQL code in the Logical Query field, use the Navigator to select an analysis or tables to preview.
    6. Click Load.
  3. In Microsoft Power BI Desktop, create visualizations and save the project in a Power BI Desktop document (PBIX). See Integrate Oracle Analytics Cloud with Microsoft Power BI (Preview).