Forum Discussion

njrandell's avatar
njrandell
Icon for Helper I rankHelper I
9 years ago
Solved

Rest API and Dashboard not always updating

I'm having various problems with the rest api and updates.   I've created 3 datasets, one Push, one PushStreaming and one Streaming. When I add tiles on a dashboard showing values from the PushStr...
General Comment
  • njrandell's avatar
    njrandell
    9 years ago

    I may have solved it - after looking carefully at the Json being sent up when adding rows, I found that I was camel casing the data.

     

    So I was sending up

    {
  "rows": [
    {
      "timestampUtc": "2017-04-07T07:20:47.8260389Z",
      "intCounter": 726,
      "floatCounter": 952.93173610834947,
      "flag": false,
      "Label": "Label 14"
    }
  ]
}

    where I really should have been sending

    {
  "Rows": [
    {
      "TimestampUtc": "2017-04-07T07:20:47.8260389Z",
      "IntCounter": 726,
      "FloatCounter": 952.93173610834947,
      "Flag": false,
      "Label": "Label 14"
    }
  ]
}

    Hopefully this is the root cause of my issues!

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
njrandell wrote:

Another update - some of my datasets are updating, others aren't.

 

Is there anywhere I can see log files or work out what is going on?

njrandell

I think there might be some kind of log in Power BI Service, however it seems not accessible for users. You can try to submit a support ticket. 

njrandell's avatar
njrandell
Icon for Helper I rankHelper I
9 years ago

I may have solved it - after looking carefully at the Json being sent up when adding rows, I found that I was camel casing the data.

 

So I was sending up

{
  "rows": [
    {
      "timestampUtc": "2017-04-07T07:20:47.8260389Z",
      "intCounter": 726,
      "floatCounter": 952.93173610834947,
      "flag": false,
      "Label": "Label 14"
    }
  ]
}

where I really should have been sending

{
  "Rows": [
    {
      "TimestampUtc": "2017-04-07T07:20:47.8260389Z",
      "IntCounter": 726,
      "FloatCounter": 952.93173610834947,
      "Flag": false,
      "Label": "Label 14"
    }
  ]
}

Hopefully this is the root cause of my issues!