Thought Sirui Sun's recent post something you all might find interesting and different. Honestly I would have never thought of using Power BI with an IoT project, but after seeing this, it almost seems silly to not use it...
Last month, we released a set of features in preview designed to make it easier than ever to display real-time streaming data in your Power BI dashboards. Check out the announcement if you haven’t already. Today, I want to show you just how easy this can be.
Many of you have expressed interest in using Power BI to display real-time sensor data. In this tutorial, we will walk you step-by-step through the entire process of setting up a Raspberry Pi weather station, and showing the resulting temperature and humidity data in real-time with Power BI. Here's a sneak peek of the end result:
Have other use cases in mind? Don't have access to the materials below? No sweat. The lessons and sample code in this tutorial are broadly applicable for a wide range of IoT scenarios. And, as always, please let us know if you have any questions, either in the comments below, or in our community forums.
With that in mind, let's get started! For this tutorial, we'll be using the following materials:
- Raspberry Pi 3 w/ Rapsbian Jessie installed
- DHT22 temperature sensor
Using Windows 10 IoT instead? No problem. Most of the steps below will apply to you as well, and we'll call out the differences where necessary.
Preparing the streaming dataset in Power BI
Hooking up the Raspberry Pi to collect temperature and humidity data ...
Reading the data and sending it to Power BI ...
Putting it all together: visualizing the data in Power BI ...
- Stay tuned for part two of our tutorial, where we'll be covering more advanced use cases, including using Azure Stream Analytics to perform time series analysis on your data
- The steps above should be broadly applicable to the wide variety of sensors available to Raspberry Pis - e.g. motion, sound, pressure, and many more. Build something cool? Let us know in the comments or in the forums! Your work could be showcased in a future blog post.
- Check out the full REST API documentation.
- Have a feature request for real-time? Let us know in UserVoice.