In this blog we will discuss how we can build blockchain prototype and see transaction data in Power BI report.
Video-
Prerequisite :
1-To configure Azure workbench and deploy blockchain app .
Please refer – https://tinyurl.com/tu9emj3
Refer Blog-https://tinyurl.com/tu9emj3
2- Download PowerBI Desktop
Step-1 Enable interaction from database firewall settings .
![](https://i2.wp.com/asifwaquar.com/wp-content/uploads/2020/06/image-23-1.png?fit=688%2C384)
Step-2 Click on Get Data in Power BI Desktop and choose SQL Server option provide sql server name from Azure Workbench DB and credentials to connect DB.
![](https://i2.wp.com/asifwaquar.com/wp-content/uploads/2020/06/image.png?fit=688%2C258)
![](https://i1.wp.com/asifwaquar.com/wp-content/uploads/2020/06/image-1.png?fit=688%2C398)
Step- 3 Connect to DB and choose tables to show chart.
![](https://i0.wp.com/asifwaquar.com/wp-content/uploads/2020/06/image-2.png?fit=688%2C407)