Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
HI @mrslyfox,
AFAIK, power bi not load/run javascript functions when you use web connector, it will get html elements and stored as text format.
In addition, you can also take a look at following link:
Call custom Javascript function in a table column
Regards,
Xiaoxin Sheng
Hello @v-shex-msft
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.