Calculating uptime with a IoT enabled test stand

[Anonymous]

I have this website that shows me if my stand is running or not: https://protected-bastion-84820.herokuapp.com/api/devices/testDevice

I am mainly looking at "lastUpdated", "state", and "speed" to verify if my test is running or not. Obviously, I can read this data and display a green or red light indicating if a test stand went down. (speed is "0" or state is "Fault")

My Question: Is there a way to calculate downtime/uptime of this test within powerBI? I think a solution could be to save a row of data whenever the state is "Fault" but I think this would take some sort of database. I was hoping to avoid having to impliment anything besides the website I linked above...

Thoughts?

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

Power bi could get data from datasurce (read data), but couldn't 'write' data to datasource.

So for your case(save a row of data whenever the state is "Fault"), you need to use a database as a transfer station and then power bi get data from it and create the report.

Regards,

Lin