Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
njrandell
Helper I
Helper I

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 PushStreaming and Streaming datasets, I can see the columns from one of the tables (I created 2 tables in each dataset) but the tiles are blank.

 

If I add data from the Push or PushStreaming datasets to a report and then pin to a dashboard then those tiles update correctly.

 

Should I be able to create a Streaming dataset using the API and then push data into a live tile? If so, is there a clear example that shows how to do this?

 

1 ACCEPTED SOLUTION

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!

View solution in original post

4 REPLIES 4
njrandell
Helper I
Helper I

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?

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

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!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.