Oracle Cloud Infrastructure Documentation

Configuring the BI Tool - Power BI

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