Oracle Cloud Infrastructure Documentation

Configuring the BI Tool - Power BI

  1. Open the Power BI Desktop tool.
  2. Click Get Data, and then filter for ODBC.
  3. Select ODBC, and then click Connect.
  4. Select the Data source that you created in Configuring the Client Machine ODBC Connector on Unsecure Big Data Service Cluster.
  5. Click Default or Custom, and then provide the connection property if you have one. If not, continue with next step.
  6. Click Connect.
  7. Upon successful connection, click Hive > Database, and then select the table to load the data and use BI functionalities.
  8. To visualize the data, click Build visual in Visualizations.
  9. Select the table and its column in Fields.