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!

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

This is annoying - no code changes and it's now working!

 

Is there somewhere we can see the detailed status of Power BI services so we know whether things are working correctly?

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

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?

  • 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!