Power BI connects to Hive and executes queries to pull the data. The load time especially on a small environment can be quite long.Īs the data loads you will get a loading screen as Selecting a few by focusing on a single fact table with a few key dimensions.

It is here you can pick andĬhoose which tables you want to view in your reports. Should now be able to drill down to your Hive schema using the Power BI If your connection was successful in Step 3 you Loading and Visualizing Hive data in Power BI Once connected you are now ready to load table data. The ODBC configuration setup in the previous step. From the ODBC wizard you will need to select For our purposes we are going to select ODBC. In Power BI click on the Get Data in the ribbon and select More…Īs you can see Power BI has a wealth of dataĬonnection options. Once successful you can now open up Power BI and User Name, and finally the name of the user connecting to Hive – in this case IP address of the HDP cluster, the Authentication Mechanism which is set to The primary areas you will want to consider is the You will want to highlight the Sample Hortonworks Open up the 64 bit ODBC Data Source Administrator and click on the

The documentation can be found here Īfter the driver installs you will need to setup a To do this you will need to download and install the ODBC driver on the Hiveserver2 allows for a connecting via standard Of dimension tables and measure (fact) tables. If you areįamiliar with data warehouse schemas, you will quickly notice the dataset is comprised Sqoop import -connect 'jdbc:sqlserver://192.168.56.101:1433 database=AdventureWorksDW2014 username=hadoop password=hadoop' 'jdbc:sqlserver:// database= username= password=' -table

Library cp sqljdbc_4.0/enu/sqljdbc4.jar /usr/hdp/current/sqoop-server/lib Following are instructions for movingĭata from SQL Server AdventureWorks to Hive: Of your cluster generating the data set as well as loading data into Power BIĪnother option would be to use Apache Sqoop to loadĭata from an existing RDBMS data source. I used a 5 GB dataset but this isĬonfigurable. I used TPC-DSĭata from the hive-testbench (see pre-reqs). (be careful of data transfer costs whenĪgain, how you get data is up to you. You will need hardware for HDP as well as a Windows or Mac boxĪ virtual environment using VMware or VirtualBox and install the HDP 2.5Ĭloud with either Azure IaaS, HDInsight, or AWS.Īnd utilize a cloud instance of HDP. For HDP I’m running a 4 node cluster in the cloud. I ended up using Windows Server 2016 Evaluation Edition How to setup the environment is up to you. Scroll down to the Add-Ons section Įxercise assumes a non-Kerberoized cluster

HDP Installation either cluster or sandbox.

Can power bi be installed on mac