Analyze Data with Power BI Desktop

Use the connection you created to the data warehouse to view and analyze the data using Power BI Desktop.

Connect to Oracle Autonomous Data Warehouse

Create a connection from Power BI Desktop to Oracle Autonomous Data Warehouse.

  1. Start Power BI Desktop on your local machine.
  2. Under Get Data, click Database and then click Oracle Database.
  3. Provide the required server information:
    • Server: Provide the name of the server you want to connect to. This name is listed in the tnsnames.ora file downloaded with the credentials wallet. For example, adw0823_high.
    • Data Connectivity Mode: Select DirectQuery to access data directly from the database.
  4. Click OK.
    A window prompts you for credentials to access the database.
  5. Click Use alternate credentials and provide the required access information:
    • User name: Provide the user name to access the server, for example Admin.
    • Password: Provide the associated password.
  6. Click Connect.
  7. Select a schema.
  8. Drag and drop one or more tables onto the preview area and then click Load to view the table data in the Power BI visualization interface.

Create a Visualization

After you connect Power BI to the data warehouse and select one or more data sources, you are ready to visualize the data.

  1. To create a visualization, drag fields from the Fields panel to the canvas for analysis. For example, if you drag a field that contains geolocation data, a map visualization is created by default.
  2. Refine the visualization, choose other display options, and combine the fields in different ways to produce useful insights. You can publish your findings as a report to the Power BI service and share your insights with others.