Fraud Detection

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 onlinefraud.pbix file from the Desktop/Fraud folder on your VM.
  2. Download and open the onlinefraud.pbix file
  3. Download and open the onlinefraudHDI.pbx file
  4. Click on Edit Query
  5. Select the first query (TestData) and then click on the Advanced Editor in the toolbar.
  6. 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.)
  7. Replace sdglcr2 with your cluster name and click on Done. (The full address will be http://CLUSTERNAME.azurehdinsight.net.)
  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. Select the second tab, Database on the left.
  13. Enter your username and password. Then select the Connect button.
  14. Select OK on the Encrypting Support alert.
  15. The TestData table will appear.
  16. 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.
  17. Select each of the next two queries on the left (Operational_Metrics and ScoresData_Prod). For each one use the Advanced Editor in the toolbar and replace sdglcr2 with your cluster name. You won't need to provide credentials again.
  18. Now close the Query Editor. Select Yes to the prompt to apply your changes.
  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