Skip to main content

PLCnext Power BI Reports

June 16, 2021 by Jeremy Tomlinson, Director of Engineering @ Fathym

Once you have your Phoenix Contact PLCnext Control data flowing to the cloud, it's time to create some Power BI reports so that you can easily monitor everything. But first things first, let's get our PLCnext Control connected to Microsoft Azure.

Phoenix Contact PLCnext

Phoenix Contact has a video at https://youtu.be/QST1RpTkdfA that shows how to connect your PLCnext controller to an Azure IoT Hub using a Node.js client. It's a great video and very informative. However, instead of going through all of the tedious steps outlined in the video of setting up an Azure resource group, the IoT Hub, storage containers, the storage endpoints, and everything else, I prefer to use Fathym's IoT Ensemble. With one click I can register my PLCnext device and immediately get access to the data for downstream use in alerts, dashboards, and visualizations. After I enroll my device in IoT Ensemble, it displays the IoT Hub connectionstring. I take the connectionstring into PLCnext Engineer to use as my Azure Key and I'm ready to rock. Here's a screenshot of my connected PLCnext Control.

IoT Ensemble List Device

The PLCnext data is immediately flowing to IoT Ensemble and I can view the data on screen. Reminder that behind the scenes in IoT Ensemble the PLCnext data is stored in Microsoft Azure in blob storage, as well as in CosmosDB.

How to access data in Microsoft Azure

Behind the scenes in IoT Ensemble the PLCnext data is stored in Microsoft Azure in blob storage, as well as in CosmosDB. Read This to learn more about accessing your data.

Fathym's IoT Ensemble is providing an easy-to-use UI for interacting with the data instead of using the Azure portal - and it saves me a ton of time and money.

Fathym IoT Ensemble

PLCnext Power BI Reports

Now that my PLCnext data is flowing to IoT Ensemble, it's time to create some Power BI reports to monitor everything. This IoT Ensemble doc explains how to import data from IoT Ensemble into Power BI and setup reports and visualizations. Here's a screenshot.

Power BI Reports

Sign up for IoT Ensemble and save your company thousands of dollars in Azure setup and management costs. Enroll your first PLCnext Control with IoT Ensemble for free. No credit card required. No Azure account required. It really is that simple.

info

Enroll your first PLCnext Control with IoT Ensemble for free.
No credit card required.
No Azure account required.