Numerical column getting added up in PowerBI report

[Anonymous]

I have created a streaming dataset with two columns, namely Column1 (Number) and Column2 (Text). I have created a report with a bar chart showing Column2 vs. Column1. When I send [{"Column1": 50, "Column2": "ABC"}] to the dataset API, the plot displays correctly with "ABC" on the x-axis and 50 on the y-axis. However, when I resend the same data, Column1's data gets added up, resulting in "ABC" on the x-axis and 100 on the y-axis.

I do not want to add the numerical column data; instead, I want to update it. Is there any way to achieve this?

Thanks,
Pratik

[lbendlin · Accepted solution]

No, you cannot update data in a streaming dataset.  Your push statement should include a UTC timestamp as well, so you can choose to plot by that timestamp, or you could use a different aggregation (max, for example), or you could add page flter to only show the data from the last x seconds etc.