Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
25 | |
3 | |
2 | |
2 | |
2 |