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