Publish IoT Hub Data to Power BI via Stream Analytics

Azure IoT is a managed service that enables secure bi-directional communication between IoT Applications and devices. It is capable of receiving and processing millions of events per second. Developers can leverage its capabilities to build scalable, full-featured IoT solutions such as managing industrial equipment used in manufacturing, tracking valuable assets in healthcare, and monitoring office building usage.

In this article, we will publish IoT Hub events hub data to Power BI Dashboard. Power BI helps analysts to visualize the data and share insights within teams or organization.

So Let’s begin.

Pre-requisites

  • IoT Hub Should be up and running.
  • Events Data received by IoT Hub should have below Schema:
{
   "MachineName":"AB01",
   "ServerName":"XXXYYZZZZ01",
   "Process":"CNC",
   "LastStatus":3,
   "Status":"Connect",
   "Time":"2020-05-30T16:18:31.7058659Z"
}

Create Stream Analytics Account

  • Search for Stream Analytics
  • Click on Add
  • Provide details and click on Create.

Create Input Dataset

  • Go to Resource
  • Click on Inputs > Add stream input > IoT Hub
  • Provide details and click on Save

Create Output Dataset

  • Click on Output > Add > Power BI
  • Authorize with Power BI Subscription Account
  • Select Power BI Workspace, provide rest of the details and Click on Save

Create Query

  • Click on Query
  • Type Below sample query and Click on Save Query
SELECT MachineName, ServerName, Status
INTO [IoTOutput]
FROM  [IoTIn]
  • Start the Stream Analytics Job

Create Power BI Dashboard

  • Login to Power BI.
  • Select Workspace. Now the Dataset published from the Stream Analytics job is available.
  • Click New > Dashboard
  • Provide Dashboard name and click on Create.
  • Portal redirects to the new dashboard.
  • Click on Edit > + Add a tile
  • Under Add a tile, select Custom Streaming Data.
  • Select the dataset published from Stream Analytics Job and click on Next.
  • Select Card type, Add Values to Axis and Legend and click on Next
  • Provide Details and Click Apply
  • Now the report is ready

Power BI can be an efficient way to use real-time data to monitor the IoT Infrastructure and device. Any prompt and proactive measures can be taken to minimize the downtime of the critical devices.



Categories: Azure, Azure IoT, Azure Stream Analytics, Power BI

2 replies

  1. Is it possible to store the stream data to a storage like table to have historical data?

    Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: