topic Re: Can not Delete rows using PowerBI REST API in Developer

Can not Delete rows using PowerBI REST API

AlexSavchenko — Fri, 06 Jan 2017 22:44:33 GMT

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

Re: Can not Delete rows using PowerBI REST API

Eric_Zhang — Mon, 09 Jan 2017 06:30:06 GMT

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

Re: Can not Delete rows using PowerBI REST API

AlexSavchenko — Mon, 09 Jan 2017 15:10:40 GMT

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.

Re: Can not Delete rows using PowerBI REST API

Eric_Zhang — Tue, 10 Jan 2017 01:13:45 GMT

@AlexSavchenko

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

Re: Can not Delete rows using PowerBI REST API

bhanudaybirla — Wed, 17 Jan 2018 10:08:49 GMT

Have you find any solution till now?

Re: Can not Delete rows using PowerBI REST API

bhanudaybirla — Wed, 17 Jan 2018 10:10:53 GMT

Have you find any solution for this?