Visualize Hive data with Microsoft Power BI using ODBC in Azure HDInsight

Learn how to connect Microsoft Power BI to Azure HDInsight using ODBC and visualize the Hive data.

Important

You can leverage the Hive ODBC driver to do import via the generic ODBC connector in Power BI Desktop. However it is not recommended for BI workloads given non-interactive nature of the Hive query engine. HDInsight Interactive Query connector and HDInsight Spark connector are better choices for their performance.

In this tutorial, you load the data from a hivesampletable Hive table to Power BI. The Hive table contains some mobile phone usage data. Then you plot the usage data on a world map:

HDInsight Power BI the map report

The information also applies to the new Interactive Query cluster type. For how to connect to HDInsight Interactive Query using direct query, see Visualize Interactive Query Hive data with Microsoft Power BI using direct query in Azure HDInsight.

Prerequisites

Before going through this article, you must have the following items:

Create Hive ODBC data source

See Create Hive ODBC data source.

Load data from HDInsight

The hivesampletable Hive table comes with all HDInsight clusters.

  1. Sign in to Power BI Desktop.
  2. Click the Home tab, click Get Data from the External data ribbon, and then select More.

    HDInsight Power BI open data

  3. From the Get Data pane, click Other from the left, click ODBC from the right, and then click Connect on the bottom.
  4. From the From ODBC pane, select the data source name you created in the last section, and then click OK.
  5. From the Navigator pane, expand ODBC->HIVE->default, select hivesampletable, and then click Load.

Visualize data

Continue from the last procedure.

  1. From the Visualizations pane, select Map. It is a globe icon.

    HDInsight Power BI customizes report

  2. From the Fields pane, select country and devicemake. You can see the data plotted on the map.
  3. Expand the map.

Next steps

In this article, you learned how to visualize data from HDInsight using Power BI. To learn more, see the following articles: