topic Re: Delete Dataset via API? in Developer

Delete Dataset via API?

sjorg — Tue, 17 Apr 2018 14:45:59 GMT

Hi,

I am trying to replace the contents of a Dataset bound to a Report. Need to do it entirely via API.

For example, initially it has X tables, with some rows.

I want to change it to Y tables, all with different names, and different row data.

1) Delete the Dataset, then create a new one, and rebind it to the Report.

I do not see the option to Delete a Dataset via API....how come?

2) The workaround I was thinking of was DeleteRows and UpdateTableSchema. But if (in the above example), Y>X, I don't see an option to AddTables to a Dataset, or UpdateSchema for a Dataset.

Anyone know how a "Swap out" for a Dataset can be accomplished via API? This is quite a roadblock.

Thanks.

Re: Delete Dataset via API?

v-micsh-msft — Fri, 20 Apr 2018 07:07:45 GMT

Yes, there is no Delete DataSet API available.

The current available method to update the DataSet Schema is:

Use the Import API to overwirte the existing one:

Import API

https://msdn.microsoft.com/en-us/library/mt243840.aspx

Regards,

Michael

Re: Delete Dataset via API?

manjirit — Thu, 14 Jun 2018 19:46:57 GMT

There is delete Dataset by Dataset ID API method available.

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/deletedatasetbyidingroup

Re: Delete Dataset via API?

sjorg — Thu, 14 Jun 2018 20:47:19 GMT

interesting - haven't tried it, but is this new? Don't think it was available earlier

Re: Delete Dataset via API?

matmarq — Mon, 30 Nov 2020 13:03:16 GMT

Hi,

I use REST API for streaming delete rows in RealTimeData. The problem is wich token authorization is dynamic.

Exist another path for this without token dynamic? I want use Power Automate to do streaming delete rows.

Thank´s for help.