This code shows how to implement the integration between Arduino and Power Bi with Python using serial communication.
Python Script creates a serial connection to Arduino and stores the data in the sqlite3 database. This data is used in PowerBi to generate reports.
You need run 3 interfaces:
- Upload *.ino code into your board
- Connect with your PC using USB cable
- Ensure the serial monitor is closed
- Run *.py code in your PC
- Choose the baude rate
In this point, you can star a new connection with sqlite3 ou use the model *.pbix into project folder.
You can use this basic stack to generate awnsome real time charts.