You can download data from Hive-Hadoop and convert it into a PowerPivot model and use it with Power View. Here is how:
1. Download and install the Microsoft ODBC Driver from here.
2. Create an ODBC driver for Hive in ODBC.
3. From Excel > Data > Get Data > ODBC Driver > Connect to your ODBC driver.