Streaming Data to Power BI from a Spin Bike

Stream your spin bike RPM data to Power BI for real time reporting and dashboarding.

May 26, 2017

4209 views

2 respects

Components and supplies

1

Arduino UNO

1

Reed Switch

1

Arduino Project Enclosure

Tools and machines

1

Hot glue gun (generic)

1

Soldering iron (generic)

Apps and platforms

1

Windows 7

1

Power BI

Project description

Code

node.js code

javascript

This allows the the arduino's serial data to be read by the windows machine. From there a PowerShell script is called to post the data to Power BI. See code comments for details

Arduino Code

arduino

This reads the reed switch data and posts it to the serial port

PowerShell code

powershell

This post the data to a Power BI streaming data set. You could probably do this in node.js, but this was quicker for our use case

PowerShell code

powershell

This post the data to a Power BI streaming data set. You could probably do this in node.js, but this was quicker for our use case

node.js code

javascript

This allows the the arduino's serial data to be read by the windows machine. From there a PowerShell script is called to post the data to Power BI. See code comments for details

Downloadable files

Wiring

Hook up From: https://learn.sparkfun.com/tutorials/reed-switch-hookup-guide

Wiring

Wiring

Hook up From: https://learn.sparkfun.com/tutorials/reed-switch-hookup-guide

Wiring

Comments

Only logged in users can leave comments

santoshkanthety

0 Followers

0 Projects

+3

Work attribution

Table of contents

Intro

2

0