Forum Discussion
Connect POWER BI to PLC
I have 100 sensors that collect the data every 3 seconds (e.g., pressure, temperature, and flow rate) from a machine and these data are going to the machine PLC. I would like to know if I can pull the data directly into the Power BI and make a dashboard to monitor data real time. The PLC is Rockwell. The way that I present my question shows that I am not an IT or computer nerd, please guide me in a simple way.
HI KJBakhsh,
You can refer to below link who mentioned about use C# programming language to get data from PLC with TCP/IP or RTU mode.
Tutorial 1: Modbus TCP/IP C# - Function 01 (01hex) Read Coils
Tutorial 2: Modbus RTU C# - CRC check sum (16-bit check sum consists of 2 8-bit characters)
Regards,
Xiaoxin Sheng
4 Replies
Hi KJBakhsh,
Maybe you can try to use programming language package these flow records and send httprequest to power bi streaming api, then create streaming tile to show records.
Reference links:
Real-time streaming in Power BI
Regards,
Xiaoxin ShengGreat! any suggestion what typo of programing language I can use!
HI KJBakhsh,
You can refer to below link who mentioned about use C# programming language to get data from PLC with TCP/IP or RTU mode.
Tutorial 1: Modbus TCP/IP C# - Function 01 (01hex) Read Coils
Tutorial 2: Modbus RTU C# - CRC check sum (16-bit check sum consists of 2 8-bit characters)
Regards,
Xiaoxin Sheng
Here is what I am lookig for....
I have 100 sensors that collect the data every 3 seconds (e.g., pressure, temperature, and flow rate) from a machine and these data are going to the machine PLC. I would like to know if I can pull the data directly into the Power BI and make a dashboard to monitor data real time. The PLC is Rockwell. The way that I present my question shows that I am not an IT or computer nerd, please guide me in a simple way.
Thanks
