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!