Forum Discussion
Calculating uptime with a IoT enabled test stand
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?
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
1 Reply
v-lili6-msftCommunity Support
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