Building a Real-Time Weather Dashboard in Microsoft Fabric: Step-by-Step Guide

[suparnababu8]

Step 1: Create the Workspace & Eventhouse

Start by creating a new workspace named RealTime-Weather-WS.

1. Click New Item.
   
2. Search for Eventhouse.
   
   
   
3. Select Eventhouse and create a new instance named Bengaluru-weather-EH.
   

Once created, Fabric automatically provisions an associated KQL Database.

Step 2: Create an Eventstream

Navigate back to the workspace and:

1. Click New Item
   
   
2. Search for Eventstream
   
   
3. Create one named bengaluru-weather-stream
   
   

This will open the Eventstream canvas where we’ll add our real-time weather sources.

Step 3: Add Weather Feed Sources

On the Eventstream canvas:

1. Click Add source --> Connect data source
   
   
2. Select New
   
   
3. Choose Public Feeds --> Real-time weather
   
   

Search for Kengeri – Bengaluru, rename the source to kengeri, and add it.

The live Kengeri weather feed now appears on the canvas.

Step 4: Add Additional Bengaluru Localities

Repeat the same steps to add more suburban Bengaluru locations.

Following this process, add all 8 Bengaluru localities you want to monitor.

Once done, you’ll see all streaming sources producing live data simultaneously.

Step 5: Add a Destination (Eventhouse)

Now we send the streaming data to Eventhouse.

1. Click Add Destination --> Eventhouse
   
   
2. Choose the previously created Bengaluru-weather-EH. Map the eventstream output to the Eventhouse table then click Save
   
   

Next:

1. Insert a processing node
   
2. Select Manage Fields
   
   
3. Add important fields such as Latitude, DateTime, and others required for reporting as follows
   

After configuring the fields, save your changes and publish the Eventstream.

At this point, your weather data is flowing live into Eventhouse.

Step 6: Build the Real-Time Dashboard

Navigate to the Eventhouse database and open the table (bengalurudb).Click on Real-Time Dashboard.

In edit mode:

1. Select a tile and click Edit
   
   
2. Add your KQL query
   
   
3. Configure the visual mapping and apply changes
   

For example, the temperature map tile uses a KQL query that extracts temperature data and plots it across locations.

Add additional tiles—for example:

• Location-wise temperature distribution
• Wind speed
• Humidity
• Real-time metrics per suburb

After configuring all visuals, click Save.

Your Real-Time Weather Dashboard is now fully operational.

Final View

Once all components are published, your workspace will include:

• Eventhouse
• Eventstream
• KQL Database
• Real-Time Dashboard
• Data mappings and transformations
  

This completes your real-time weather monitoring solution in Microsoft Fabric.

Conclusion

That’s how you can build an end-to-end Real-Time Weather Data Dashboard in Microsoft Fabric using public weather feeds.
I hope you found this blog helpful. If you have any questions or want to explore more scenarios, feel free to reach out.

Happy learning!

Acknowledgements
I would like to express my sincere gratitude to @SuryaTejaJosyul   and @rajendraongole1  for their continuous guidance and support throughout this Real-Time Intelligence (RTI) implementation. Their insights and encouragement played a key role in helping me complete this solution successfully.

-- Inturi Suparna Babu

[LinkedIn]

[ajaybabuinturi]

That's very useful for real-time data sets

[Magudeswaran_MR]

Excellent Blog for Real Time Data Analysis in Fabric

[suparnababu8]

Here is end-to-end tutorial - https://youtu.be/UikXmBF3sR8?si=y-dbjSkF08uKMUZg

[agnikroy06]

Well summarized, thanks a lot