Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sjorg
Frequent Visitor

Delete Dataset via API?

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.

 

 

1 ACCEPTED SOLUTION
v-micsh-msft
Employee
Employee

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

View solution in original post

4 REPLIES 4
matmarq
New Member

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
Employee
Employee

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

There is delete Dataset by Dataset ID API method available.

 

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.