Delete Dataset via API?

[sjorg]

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.

[matmarq]

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.

[v-micsh-msft · Accepted solution]

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

[manjirit]

There is delete Dataset by Dataset ID API method available.

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

[sjorg]

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