Connect a Virtual Warehouse and Microsoft Power BI Desktop
You learn how to connect to a Hive or Impala Virtual Warehouse from Microsoft Power
BI. You can then use Power BI to visualize the data in the Virtual Warehouse on Cloudera.
Although you configure Power BI using a Microsoft UI labeled Hive LLAP, you can use
this procedure to connect to a Hive Virtual Warehouse or to an Impala Virtual
Warehouse. After making the connection, you can use Power BI to create reports based
on data in the Virtual Warehouse.
You have access to a Cloudera Environment and a
Hive LLAP or Impala Virtual Warehouse that contains tables of data.
You know the Cloudera workload user name and
password you set in User Management in the
Cloudera Management Console. You need to use your workload user
name and its associated password to log into the Virtual Warehouse.
Log in to the Cloudera Data Warehouse service as DWUser.
Go to the Virtual Warehouses tab, locate the Hive Virtual
Warehouse you want to connect to, and click > Copy JDBC URL.
This copies the JDBC URL to your system's clipboard.
Paste the copied JDBC URL into a text file. It should look similar to the
following:
From the text file where you just pasted the URL, copy the host name from the
JDBC URL to your clipboard. For example, in the URL shown in the step above, the
host name is: