Makers Blog

PLCnext Power BI Reports

matt.jackson 06 July 2021 min. read
285 views 0 comments

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 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.

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.

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.

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.

Note:

The Makers Blog shows applications and user stories of community members that are not tested or reviewed by Phoenix Contact. Use them at your own risk.

Discussion

Please login/register to comment

Login/Register

Leave a Reply

Newsletter
Never miss a new article
Sign up for the newsletter
Never miss news about PLCnext Technology
Get interesting content via newsletter four times a year
Receive exclusive information before all other users