Loan Credit Risk

Visualizing Results with PowerBI


This page shows how to refresh data for the PowerBI file on your VM. If you want to instead download the file to your own computer, first open the firewall on your VM by execute the following command in a PowerShell window on the VM:
netsh advfirewall firewall add rule name="SQLServer" dir=in action=allow protocol=tcp localport=1433 

Then follow the SQL Server On-Premises instructions.

These instructions show you how to replace the cached data in the PowerBI dashboard with data from your SQL Server VM on Azure solution. SQL Server On-Premises solution, or any SQL Server other than localhost. HDInsight Spark solution.

First, try refreshing the data using the Refresh button on the toolbar. Use your Windows credentials if prompted.

If this does not work, you may need to modify the connection information by using the steps below.

  1. Open the LoanCreditRisk.pbix file from the Desktop/Loans folder on your VM.
  2. Download and open the LoanCreditRisk.pbix file
  3. Download and open the LoanCreditRisk HDI.pbx file.
  4. Setup an ODBC connection to your cluster.
  5. Click on Edit Query
  6. Select the first query (TestData) and then click on the Advanced Editor in the toolbar.
  7. Replace localhost with your server name and click on Done. (If you are using an Azure VM, such as the one deployed using the 'Deploy to Azure' button on the Quick start page, use the IP address for the server name.)
  8. After a moment you'll see an alert asking for Permision to run the query. Click on Edit Permission
  9. Press Refresh on the top toolbar.
  10. On the Native Database Query dialog, click the Run button.
  11. On the Please specify how to connect alert, click on Edit Credentials
  12. Next you will see a SQL Server database login. Use the Windows tab to connect with your Windows credentials, or use the Database tab to supply your username and password if you have one. Then select the Connect button.
  13. Select OK on the Encrypting Support alert.
  14. The TestData table will appear.
  15. Select each of the remaining queries on the left. For each one use the Advanced Editor in the toolbar and replace localhost with your server name. You won't need to provide credentials again.
  16. Now close the Query Editor. Select Yes to the prompt to apply your changes.
  17. Click on Refresh in the top toolbar.
  18. Enter your username and password for the cluster.
  19. You are now viewing data from your SQL DatabaseHive tables, rather than the imported data that was part of the initial solution package.
  20. Subsequent clicks of Refresh will work without further authentication steps.
  21. When you close the file, save your changes.

< Home