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. Prerequisites for Microsoft Power BI Integration (Preview)

Prerequisites for Microsoft Power BI Integration (Preview)

Before you start, make sure that you have the following:

  • A Windows machine with the latest version of Microsoft Power BI Desktop installed, or the April 2022 version at a miminum. Microsoft Power BI Pro or Premium aren't supported.

    To consume Oracle Analytics Cloud analyses in Microsoft Power BI Desktop using the Navigator (instead of copying SQL from Oracle Analytics Cloud Classic), use the latest January 2023 Update of Oracle Analytics Cloud and install V1.2 or higher of Power BI connector for Oracle Analytics Cloud.

  • A Windows machine with the latest Oracle Analytics Client Tools installed. See Download page for Oracle Analytics Client Tools.
  • User role privileges in Oracle Analytics Cloud:
    • To consume tables in subject areas, you need BIContentAuthor role privileges or higher.
    • To consume analysis reports, you need BIConsumer role privileges or higher.
  • A semantic model in Oracle Analytics Cloud.

    If you used Model Administration Tool to develop your semantic model, make sure that subject areas and tables are available in the Presentation layer.