Visualize and analyze your Azure IoT Central data in a Power BI dashboard
This topic applies to administrators and solution developers.
Use the Power BI Solution for Azure IoT Central V3 to create a powerful Power BI dashboard to monitor the performance of your IoT devices. In your Power BI dashboard, you can:
- Track how much data your devices are sending over time
- Compare data volumes between different telemetry streams
- Filter down to data sent by specific devices
- View the most recent telemetry data in a table
This solution sets up a pipeline that reads data from your Continuous Data Export Azure Blob storage account. The pipeline uses Azure Functions, Azure Data Factory, and Azure SQL Database to process and transform the data. you can visualize and analyze the data in a Power BI report that you download as a PBIX file. All of the resources are created in your Azure subscription, so you can customize each component to suit your needs.
To complete the steps in this how-to guide, you need an active Azure subscription. If you don't have an Azure subscription, create a free account before you begin.
Setting up the solution requires the following resources:
- A version 3 IoT Central application. To learn how to check your application version, see About your application. To learn how to create an IoT Central application, see Create an Azure IoT Central application.
- Continuous data export configured to export telemetry, devices, and device templates to Azure Blob storage. To learn more, see How to export IoT data to destinations in Azure.
- Make sure that only your IoT Central application is exporting data to the blob container.
- Your devices must send JSON encoded messages. Devices must specify
contentEncoding:utf-32in the message system properties.
- Power BI Desktop (latest version). See Power BI downloads.
- Power BI Pro (if you want to share the dashboard with others).
If you're using a version 2 IoT Central application, see Visualize and analyze your Azure IoT Central data in a Power BI dashboard on the previous versions documentation site.
To set up the pipeline, navigate to the Power BI Solution for Azure IoT Central V3 page on the Microsoft AppSource site. Select Get it now, and follow the instructions.
When you open the PBIX file, be sure the read and follow the instructions on the cover page. These instructions describe how to connect your report to your SQL database.
The PBIX file contains the Devices and Telemetry report shows a historical view of the telemetry that has been sent by devices. It provides a breakdown of the different types of telemetry, and also shows the most recent telemetry sent by devices.
You can access all the Azure resources that make up the pipeline in the Azure portal. All the resources are in the resource group you created when you set up the pipeline.
The following list describes the role of each resource in the pipeline:
The Azure Function app triggers each time IoT Central writes a new file to Blob storage. The functions extract data from the telemetry, devices, and device templates blobs to populate the intermediate SQL tables that Azure Data Factory uses.
Azure Data Factory
Azure Data Factory connects to SQL Database as a linked service. It runs stored procedures to process the data and store it in the analysis tables.
Azure Data Factory runs every 15 minutes to transform the latest batch of data to load into the SQL tables (which is the current minimal number for the Tumbling Window Trigger).
Azure SQL Database
Azure Data Factory generates a set of analysis tables for Power BI. You can explore these schemas in Power BI and use them to build your own visualizations.
The Power BI Solution for Azure IoT Central V3 page on the Microsoft AppSource site includes a link to a cost estimator for the resources you deploy.
Now that you've learned how to visualize your data in Power BI, the suggested next step is to learn How to manage devices.