Forum Discussion

mrslyfox's avatar
mrslyfox
Helper II
8 years ago

Real Time data from local measuring device

Hello,

 

we have measuring controller, which has integrated web portal to access real-time measures.

We access web page by the link http://10.30.61.1/awp/Demo/IOCounter.html

Inside of html I see folowing code

:="webdata".counter:;:="webdata".HTMLcolor:

 

<script type="text/javascript">
function loadXMLDoc() {
var xmlhttp = new XMLHttpRequest();

xmlhttp.onreadystatechange = function() {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
myFunction(xmlhttp.responseText);
}
}

xmlhttp.open("GET", "IOCounter.htm", true);
xmlhttp.send();
}

function myFunction(response) {

var result;
result = response.split(";");
document.getElementById ("id01").style.backgroundColor = result[1];
document.getElementById ("id01").innerHTML = result[0] + " f/h";
}

loadXMLDoc();
setInterval(loadXMLDoc, 1000);
</script>

 

I can add it PowerBI desktop as a Web source and manually I can refresh measured value, but

how can I push this data from controller to PowerBi service ?

Need Help

2 Replies

    • mrslyfox's avatar
      mrslyfox
      Helper II
      8 years ago

      Hello Anonymous

       

      Here is My test powershell script to push data to PBI service

       

      while($true){
      $endpoint = "https://api.powerbi.com/xxxxxxxxxx"

      $payload = @{

      "Measured" =Get-Random -Minimum 10 -Maximum 100

      "DateTime" =Get-Date -Format F
      "MachineName" ="Ford"
      "TargetValue" =80
      "MinValue" =10
      "MaxValue" =100

      }
      Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))
      }

       

      and with second Script, which can get counter result from Measuring device

       

      $WebResponse = Invoke-WebRequest "http://10.20.30.1/awp/Ford/IOCounter.htm"
      $WebResponse.Content

       

       

      Two problem I have (for the lack of scripting knowledges) 

      1. I have no idea how to put result from second script into the 'Measured" = 

      2. result from second script return value with char " ; ", like: 25000;

      and I need to delete it.