Created on 10-29-202011:55 AM - edited 01-19-202111:24 AM
A great way to connect Power BI desktop to CDP Public Cloud is using the Cloudera Data Warehouse Experience with Hive LLAP.
CDP Public Cloud environment with Data Warehouse Experience using either Hive LLAP or Impala
User will need a CDP login and will need to set up their Workload Password
From their CDP login, they will need the Workload User Name and Workload Password
Both Impala and Hive LLAP Virtual Warehouses will work with the Hive LLAP driver that is included with Power BI. The steps below will work for both. It is important to include port 443 when entering the server string in Step 6.
Steps to connect Power BI to CDW with Hive LLAP
From within the DW experience in the CDP Management console, select the Virtual Warehouse you want to use and click the and select Copy JDBC URL:
From that string, you will only need the bold portion such as the following: