apache-hadoop-connect-hive-power-bi-directquery.md

title	description	services	ms.service	author	ms.author	ms.reviewer	ms.custom	ms.topic	ms.date
Visualize Interactive Query Hive data with Power BI in Azure HDInsight	Use Microsoft Power BI to visualize Interactive Query Hive data from Azure HDInsight	hdinsight	hdinsight	hrasheed-msft	hrasheed	jasonh	hdinsightactive	conceptual	11/06/2018

Visualize Interactive Query Apache Hive data with Microsoft Power BI using direct query in Azure HDInsight

This article describes how to connect Microsoft Power BI to Azure HDInsight Interactive Query clusters and visualize Apache Hive data using direct query. The example provided loads the data from a hivesampletable Hive table to Power BI. The hivesampletable Hive table contains some mobile phone usage data. Then you plot the usage data on a world map:

You can leverage the Apache 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 Apache Spark connector are better choices for their performance.

Prerequisites

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

• HDInsight cluster. The cluster can be either an HDInsight cluster with Apache Hive or a newly released Interactive Query cluster. For creating clusters, see Create cluster.
• Microsoft Power BI Desktop. You can download a copy from the Microsoft Download Center.

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....

   

3. From the Get Data pane, type hdinsight in the search box. If you don't see HDInsight Interactive Query (Beta), you need to update your Power BI Desktop to the latest version.

4. Select HDInsight Interactive Query (Beta), and then select Connect.

5. Select Continue to close the Preview connector warning dialog.

6. From HDInsight Interactive Query, select or enter the following information:

   • Server: Enter the Interactive Query cluster name, for example myiqcluster.azurehdinsight.net.

   • Database: For this tutorial, enter default.

   • Data Connectivity mode: For this tutorial, select DirectQuery.

   

7. Click OK.

8. Enter the HTTP user credential, and then click OK. The default username is admin

9. From the left pane, select hivesampletale, and then click Load.

   

Visualize data on a map

Continue from the last procedure.

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

   

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. For more information on data visualization, see the following articles:

• Visualize Apache Hive data with Microsoft Power BI using ODBC in Azure HDInsight.
• Use Apache Zeppelin to run Apache Hive queries in Azure HDInsight.
• Connect Excel to HDInsight with the Microsoft Hive ODBC Driver.
• Connect Excel to Apache Hadoop by using Power Query.
• Connect to Azure HDInsight and run Apache Hive queries using Data Lake Tools for Visual Studio.
• Use Azure HDInsight Tool for Visual Studio Code.
• Upload Data to HDInsight.