Search
  • Karthik

Azure Stream Analytics - Streaming Dashboard in PBI

Updated: Feb 27

2 Minute Read

Quick Intro to Azure Stream Analytics


To gain powerful insights from a streaming source the best possible service in azure is "Azure Stream Analytics". It is a real-time analytics and complex event-processing engine that is designed to analyze and process high volumes of fast streaming data from multiple sources. Let's quickly understand how to configure, implement and create a streaming dashboard in Power BI service.


  1. Login to Azure portal , create a IoT Hub Resource

  2. Then create a IOT device and name it


3. Now, you need to copy the connection string from step 2

and paste it in an actual IOT device ( in this case we will use a

IOT simulator. https://azure-samples.github.io/raspberry-pi-web-simulator/ )

( note the connection-string in the image below , this will your IOT device connection string)

4. Run the simulator, this will start sending messages to the resource created in

step 2.


5. Create a Stream Analytics job. Configure input and output job/alias.

6. Input will be your IOT device and output will be your PowerBI service

( Ensure your PowerBI service is authenticated and uses same credential)


7. Copy the query in the above screenshot in the query tab to get average humidity and temperature ( Ensure your input, output alias is the same as in above screenshot)

8. Run the query and name your PowerBI streaming dataset and table. In PBI service create a dashboard and streaming tiles, You should see the below gif.




References: Microsoft site and a big shout out to Adam -> check out his YouTube https://www.youtube.com/watch?v=NbGmyjgY0pU&t=1283s


Love to hear your comments...Happy blogging!!

6 views0 comments