Clusterd comun chart not showing correct data

[Anonymous]

Hello community,
I am posting an issue I've encountered while showing data coming from a Streaming dataset displayed in my Dashboard.
In the screenshot attached you can see how the highlighted date is not present in the posted data:

[
 {
"subscribed": 3,
"experimentName": "uniqueness_KxgcX",
"time": "2022-07-28T22:00:00.000Z"
 },
 {
"subscribed": 2,
"experimentName": "uniqueness_9ZVHo",
"time": "2022-07-28T22:00:00.000Z"
 },
 {
"subscribed": 1,
"experimentName": "uniqueness_VBeEk",
"time": "2022-07-28T22:00:00.000Z"
 },
 {
"subscribed": 2,
"experimentName": "uniqueness_VBeEk",
"time": "2022-09-16T22:00:00.000Z"
},
 {
"subscribed": 4,
"experimentName": "uniqueness_KxgcX",
"time": "2022-09-21T22:00:00.000Z"
 },
 {
"subscribed": 5,
"experimentName": "uniqueness_KxgcX",
"time": "2022-09-24T22:00:00.000Z"
 },
 {
"subscribed": 23,
"experimentName": "uniqueness_KxgcX",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"unsubscribed": "2",
"experimentName": "uniqueness_9ZVHo",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"subscribed": 23,
"experimentName": "uniqueness_VBeEk",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"subscribed": 23,
"experimentName": "uniqueness_9ZVHo",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"unsubscribed": "2",
"experimentName": "uniqueness_KxgcX",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"unsubscribed": "2",
"experimentName": "uniqueness_VBeEk",
"time": "2022-09-28T22:00:00.000Z"
 }
]

NOTE: we know there is an offset of 1 day but there is no mention of 24th.

Any suggestion are welcome,
thanks in advance!

Dashboard

[Anonymous]

Hello @lbendlin ,
thanks for your reply.
Yes, in the API definistion of my Streaming Dataset, both "subscribed" and "unsubscribed" fields defined, but only one at the time will be sent.
Example:

[
{
"subscribed": 23,
"experimentName": "uniqueness_9ZVHo",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"unsubscribed": "2",
"experimentName": "uniqueness_KxgcX",
"time": "2022-09-28T22:00:00.000Z"
 },
...
]

Here a screenshot on how my Streaming Dataset is configured:

[lbendlin]

Keep in mind that the Power BI service runs on Zulu time (UTC) . Maybe your event got shifted to another day based on your viewer timezone.

[Anonymous]

Hello @lbendlin,
I do not think that the timezone can be the cause in the issue I am describing because the difference in time between the data sent and the graph is of days.
So, I am positive that the data above it's what I am sending to PowerBi but I am not able to see/debug what the Streaming Dataset is reiceving/interpreting. Do you know if there is a way to do that in PowerBi?

[lbendlin]

You can use PowerShell or Postman to push rows manually and observe if they have been added to the dataset.

I assume you have history enabled?

[Anonymous]

Yes, using cUrl requests still produce the same outcome: data sent in are not correctly shown (as per date, not per value).
History is not enabled, we are pushing historical data up to 6months prior, which is making the history functionality not really needed

[lbendlin]

please show the definition of your streaming dataset.  Are both "subscribed" and "unsubscribed" fields defined?