Loan Credit Risk

Set up Connection between Hive and PowerBI

Follow the instructions below to set up a connection between your Hive table and PowerBI. Perform these steps after you have created the Hive tables by executiong the development_main.R and production_main.R scripts.

  1. Download and install the Spark ODBC driver. If you already have this driver, make sure it version 1.2.4.1005 or greater.
  2. Push the Windows key on your keyboard
  3. Type ODBC
  4. Open the correct app depending on what type of computer you are using (64 bit or 32 bit). To find out if your computer is running 32-bit or 64-bit Windows, do the following:
    • Open System by clicking the Start button, clicking Control Panel, clicking System and Maintenance, and then clicking System.
    • . Under System, you can view the system type
  5. Click on Add
  6. Select Microsoft Spark ODBC Driver and click Finish
  7. Under Name, Enter loan credit risk. (Make sure you use this name exactly as shown here as it is the one PowerBI expects.) Add the Host name (of the form myclustername.azurehdinsight.net).
  8. Press Test.
  9. Press OK in the new popover. This will close the popover and return to the previous popovers.
  10. Now that the Data Source is tested. Press OK.
  11. Finally, click OK and close the window.

    12. You are now ready to use this connection in PowerBI. Return to Visualizing Results with PowerBI.