top of page
  • Writer's pictureKarthik

Azure Stream Analytics - Streaming Dashboard in PBI

Updated: Feb 27, 2022

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

( 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

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

23 views0 comments

Recent Posts

See All

Looking for a comprehensive code Analysis T-SQL plugin?

Look no further than SQL Prompt - A Redgate product that truly improves productivity of your T-SQL developers coupled with great code-quality guidelines. Often Organizations struggle to measure code-q


bottom of page