Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Blank Line Chart with Streaming

Hello!

 

I have created a Streaming Dataset and if I create a Line Chart from the Report Page the graph is showed with no problem. But I have to do a manual refresh. 

 

But if I go to the Dashboard and add a streaming data tile, with line chart type, I get a blank chart. What can I do? If I put on a card instead the number shows. 

 

Its driving me insane can you please help me?

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello Anonymous ! I set up like this:

       

      v-alq-msft  If it helps, here is the Powershell Code, used from Guyinacube, did I do something wrong?

      $endpoint = "Removed for security reasons"

      while($true)
      {

      $ComputerCPU = (Get-WmiObject -Class win32_processor -ErrorAction Stop | Measure-Object -Property LoadPercentage -Average | Select-Object Average).Average

      $ComputerMemory = Get-WmiObject -Class win32_operatingsystem -ErrorAction Stop
      $UsedMemory = $ComputerMemory.TotalVisibleMemorySize - $ComputerMemory.FreePhysicalMemory
      $Memory = (($UsedMemory/ $ComputerMemory.TotalVisibleMemorySize)*100)
      $RoundMemory = [math]::Round($Memory, 2)

      $Date = Get-Date -DisplayHint Date -Format MM/dd/yyyy

      $Time = Get-Date -DisplayHint Time -Format HH:mm:ss

      #$RoundMemory
      #$ComputerCPU 
      #$Date
      #$Time

      $payload = @{
      "Date" =$Date
      "Time" =$Time
      "CPU" = $ComputerCPU
      "Memory" = $RoundMemory
      }
      Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))

      Write-Host "Date: " $Date " Time: " $Time " CPU: " $ComputerCPU " Memory: " $RoundMemory

      sleep 2
      }

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

        According to your provided screen shot, it seems OK. Could you please create a line chart visual with field Time and CPU and check if the data can display normally? I need to check if there is any problem in field Time...

        In addition, please try to update Powershell codes as below and check if it works:

        while($true)
        {

        $ComputerCPU = (Get-WmiObject -Class win32_processor -ErrorAction Stop | Measure-Object -Property LoadPercentage -Average | Select-Object Average).Average

        $ComputerMemory = Get-WmiObject -Class win32_operatingsystem -ErrorAction Stop
        $UsedMemory = $ComputerMemory.TotalVisibleMemorySize - $ComputerMemory.FreePhysicalMemory
        $Memory = (($UsedMemory/ $ComputerMemory.TotalVisibleMemorySize)*100)
        $RoundMemory = [math]::Round($Memory, 2)

        $Date = Get-Date -DisplayHint Date -Format MM/dd/yyyy

        $Time = Get-Date -DisplayHint Time -Format HH:MM:ss

        #$RoundMemory
        #$ComputerCPU
        #$Date
        #$Time

        $endpoint = "Removed for security reasons"
        $payload = @{
        "Date" =$Date
        "Time" =$Time
        "CPU" = $ComputerCPU
        "Memory" = $RoundMemory
        }
        Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))

        Write-Host "Date: " $Date " Time: " $Time " CPU: " $ComputerCPU " Memory: " $RoundMemory

        sleep 2
        }

        Best Regards

        Rena