Display Data from SICK Air Flow Sensor OPC UA in Node-RED Dashboard and Power BI Dashboard

continuing from the previous video about the sick air flow sensor with OPC UA feature in this video I will demonstrate how to display the variable values from the sensor on the Node red dashboard and also how to display them in powerbi let's take a look most machines on the production line require Air Supply typically provided by an air compressor in utilizing this air compressed we need to monitor its usage hence the necessity for a sensor capable of capturing parameters of air usage the sick air flow sensor is one of the sensors we can utilize to monitor compressed air usage several values that can be captured include pressure temperature energy volume volumetric flow rate mass mass flow and velocity the sick airflow sensor can be powered simply by a Poe switch and can connect to the network with the OPC UA feature this sensor can act as an OPC UA server making it easy to retrieve its data by using node red installed on a computer computer connected to the network similar to the previous video we can retrieve real-time variable values from the sensor in this video the retrieved data will be displayed on a dashboard additionally to enable viewing the data outside the internal Network we can send this data to powerbi streaming data allowing it to be displayed on a dashboard within powerbi this is the airflow hose connection procedure starting from the compressor outlet and entering the sensor's inlet according to the flow Direction indicated on the sensor then from the sensor Outlet it will enter the system within the machine to power up the sensor you need to use a switch with Poe power over ethernet capability additionally connect the computer to switch that will retrieve data from the sensor to the network for setting the IP address please refer to my previous video next to obtain the node ID for each variable we need need software like UA expert I've also explained this in the previous video the first step is to add a server according to the OPC UA address of the sensor then establish a connection by pressing the connect button so that in the address space field a list of data available from the OPC UA server will appear drag and drop the variables from the process data into the data access view field this way we can view the node ID for each variable that we will monitor from the OPC UA [Music] [Applause] [Music] server now that we have obtained the node ID for each variable we will use these node IDs in node red here is the node red flow code starting from the trigger node this trigger will run initially and then repeat every 5 Seconds next from the trigger node connected to the OPC UA item node for all the variables whose data you want to retrieve in the item column ensure that the input values correspond to the node IDs obtained from the UA expert software in the previous step select the data type as float and fill in the names according to the variables do the same for the next [Music] variable [Music] next connect all those OPC UA item nodes to the OPC UA client node configure its endpoint according to the OPC UA address on the sensor the output from the OPC UA client node will be separated based on its topic using switch node this topic serves to distinguish the values obtained from each node ID on the OPC UA server the output from each node ID will have its value extracted as the message payload using a function node I will retrieve its float value and determine the number of decimal places to [Music] display from the payload generated by the function node for each variable connect them to the visualization node to be displayed on the Node red dashboard I am using visual gauges for some variables as well as text nodes and chart nodes to display historical data in chart [Music] [Applause] [Music] form this is the display of the dashboard we've created it includes several visual gauges to Showcase real-time data for temperature pressure flow velocity mass flow rate and volumetric flow rate energy mass and volume are presented in text format at the bottom there's a chart displaying historical data for pressure and velocity [Music] next let's create a streaming data set in powerbi to send the sensor data received by node red in powerbi select new then choose streaming data set select API and click next fill in the data set name for example sflow meter in the field below input the variables that will be received in their data format start with the variable temperature and include all sensor data including datetime data for time stamp [Music] information after filling in all the variables and their data formats we will obtain a Json format that needs to be sent from node red to be received by powerbi next click create then we'll get a push URL that we'll use to send data from node red to powerbi to create a report on the streaming data set you've created you can enable historic data analysis back to node red here's the modified node red flow from the previous one to send data to powerbi from each variable's function node I'm using a change node to store data into flow variables for each sensor parameter then from the trigger node I connect it to a delay node to wait for data to be received from OPC UA which is then stored in flow variables for each sensor parameter next using a change node extract data from each flow variable to become the payload message next connect to a function node to create a Json payload that will be sent to powerbi the Json format set must match the Json format we created when setting up the streaming data set in powerbi next connect it to an HTTP request node choose the post method and fill in the URL with the push URL obtained when creating the streaming data set in powerbi after the data is successfully sent to the streaming data set in powerbi we can create a dashboard in powerbi when adding a tile choose custom streaming data and select the name of the streaming data set we created earlier then fill in the type of visualization and the fields to be displayed on the [Music] dashboard continue this process for all parameters from the sensor that will be displayed on the powerbi [Music] dashboard [Music] in addition to visual gauges I also used visual cards for some variables such as energy mass and volume to view historical data similar to what is a available on the Node red dashboard I used a visual line chart to display pressure and velocity data this is just an example dashboard that I created you can customize it according to your [Music] needs [Music] thank you for watching in this video we were able to read the values of variables from the sensor using the opcua server feature each variable read by the sensor is distinguished based on the Node ID on OPC UA which we obtained using the UA expert application from these node d s we can read the values of each variable in node red and display them on the Node red dashboard Additionally the values we obtained from node red can be sent to powerbi as a streaming data set which can then be displayed on the powerbi dashboard allowing access from anywhere I hope this video proves useful in processing data originating from sensors see you in the next video

Channel: Yaser Ali Husen

Views: 498

Keywords:

Id: 7VLzjSs3CdY

Length: 10min 53sec (653 seconds)

Published: Sun Mar 03 2024