Search This Blog

Monday, September 27, 2021

BME280 Sensor with Raspberry Pi streaming to Power BI

A circuit using a Adafruit BME280 I2C or SPI Temperature, Humidity, Pressure Sensor, connected to a Raspberry PI (I used one of my old Raspberry Pi B-Models). The sensor values is read by a PHP script running on the Raspberry PI, the values then get sent to a Power BI streaming dataset via API which displays data on a Power BI dashboard.

Circuit Diagram (check it here Ciruito.io):


PHP Script (get it here GitHub):


You can setup the Raspberry Pi to when starting the OS (I use Raspbian) to automatically execute the script after boot-up (google it!). In the script you will need to just change the REST_API_URL variable, to your streaming dataset API end-point address. 
(REST API endpoint format: https://api.powerbi.com/beta/<tenant id>/datasets/<dataset id>/rows?key=<key id>)

Power BI Streaming Dataset:


After creating a Streaming dataset, Power BI will create a API end-point where you can POST data to:


Then just build a Power BI Dashboard on the created streaming dataset:


The Setup:


Oor en uit!

No comments: