Microsoft’s PowerBI provides the ability to easily generate powerful reports from SQL DB databases using Power BI Desktop and then publish them to http://www.powerbi.com.
This section contains a step by step walkthrough of how to connect to Azure Blockchain Workbench’s SQL Database from within PowerBI desktop, create a report and deploy that report to http://www.powerbi.com.
Download PowerBI desktop by clicking on the “Get” button at https://aka.ms/pbidesktopstore
Once installed, open the application and click on the “Get Data” button.
Select SQL Server from the list of data source types
Provide the server and database name in the dialog shown below. Specify whether you want to import the data or perform a DirectQuery then click the Ok button.
You will now provide the database credentials to access Azure Blockchain Workbench. Click on the “Database” link on the side of the dialog and enter your credentials.
If you are using the credentials created by the Azure Blockchain Workbench deployment process, the username will be dbadmin and the password will be the one you provided during deployment.
Once connected to the database, the Navigator dialog will display the tables and views available within the database. The views are designed for reporting and are all prefixed ‘vw’.
Select the views you wish to include. For demonstration purposes we will include vwContractAction which will provide details on all of the actions that have taken place on a contract.
You can now create and publish reports as you normally would with PowerBI.