Can not Delete rows using PowerBI REST API

[AlexSavchenko]

Hi all,

I have a C# script which fill in Streaming DataSet. It works fine.

When I try to delete all rows from dataset, I get error "(404) not found at System.Net.HttpWebResponse.GetResponse()".

I use instructions from https://msdn.microsoft.com/en-us/library/mt238041.aspx for both operations (POST, DELETE)

The only difference from instruction, - I do not use this autorisation stuff:

request.Headers.Add("Authorization", String.Format("Bearer {0}", token)); 

I beleave it no related to my case moreother POST works with no problem).

Need help.

Thanks

[Eric_Zhang]

@AlexSavchenko

That DELETE API is to delete the rows from one table in a normal dataset. I don't think it is applicable to the streaming dataset, as the streaming dataset doesn't contain any explicit table.

How do you call the API and why do you have to delete data when using Streaming DataSet.

By the way, the Real-time streaming in Power BI is still in preview, for any feature request, you can confirm in forum and submit your idea at Power BI Ideas and vote it up.

[bhanudaybirla]

Have you find any solution till now?

[AlexSavchenko]

Thank you v-lvzhan-msft,

I am trying to build live stream dashboard based on Heatmap visualization as explained here: 

https://community.powerbi.com/t5/Best-Visual-Contest/Heatmap/cns-p/7551

I have got heatmap and it looks great, but with time it shows more and more data, when I actually need to represent dots only for last say 10 minutes.

Solution is: once per minute delete all existing rows from dataset and load new rows.

But I can not find the way to delete it.

I did not know, that Delete API has some issues for Live Stream, will try to communicate with HeatMAp Visualisation developers,

Thanks.

[bhanudaybirla]

Have you find any solution for this?

[Eric_Zhang]

@AlexSavchenko

Streaming data using Heatmap? Could you clarify that the Streaming DataSet in you post refers to this?