Update rows Rest API
Provide API to update rows in an uploaded dataset
Sauskethorpido
shared this idea
Asked the team to look into this
32 comments
-
Arturo
commented
Any updates on CRUD operations for the REST API?
-
tchua
commented
I'm stuck with a simple service because this feature is not available. Neither does it seem possible to create a unique primary key in the tables to avoid duplicate entries. Not sure how this does not have priority over other features.
-
Alex
commented
deto - we need to be able to update datasets. Otherwise this feature is unusable for us as an ISV
-
Anonymous
commented
I need this feature too.
The workaround of deleting then adding new data right after causes the dashboard tiles to display (BLANK) for a few seconds, making that approach unusable.
-
Praveen Mishra
commented
Must have feature any update on it by when this will be available.
-
Anonymous
commented
Yes.. this is a must to have feature. Cant imagine basic CRUD operations missing in a microsoft product.
-
Raju
commented
Hi, Any update on this change request. I am also having problem to add records in existing dataset (created by uploading the pbix file from desktop). I want to refresh the dataset by sending new rows via rest api.
-
martin knight
commented
is this going to happen? having to delete all the rows of data and reinsert them all just because 1 field in 1 row has changed seems like a bad idea.
-
Alison Hughes
commented
Ability to search for a set of rows and alter them would save a lot of data refresh traffic. If a row is added incorrectly then the only way to correct this is to delete all the rows and re add. I am dealing with large quantities of data, so the rebuild can take hours, and hitting powerbi with thousands of add row requests.
-
Favna
commented
More than 2 years since this was opened and still nothing? This is super super essential of any Database. Did no one teach PowerBI about CRUD (Create Read Update Delete)?
-
Joris
commented
+1 Vote. This is essential for syncing with evolving data sources
-
Steve Menke
commented
I just started to look into use push data sets and I updating rows is a common use case for my data. So this is a must have.
-
Zeeshan Qadir
commented
@charles sterling (Admin, Microsoft Power BI)
Any update on this feature request? Is this feature coming or it's discarded by the team?
-
Arunkumar T D
commented
This is must to have. Even in Delete option, all the records are deleted. not a specific row. This is making us handicap to provide solution for the tables with 100,000+ records. This is very impractical to delete and insert rows every time. Please enable this feature ASAP.
-
Mo
commented
Also want to ask if there has been any progress in the last 6 months?
-
Anonymous
commented
Charles Sterling, has there been any progress in this issue? Or is there a timeline for implementing this feature?
-
Baskar Vijayan
commented
Anyone can help me here how can i delete the rows in push streaming dataset using REST API Call
-
Anonymous
commented
Has there been any updates about this since January?
-
Anonymous
commented
Has anyone tried this: https://msdn.microsoft.com/en-US/library/mt748181.aspx SetAllConnections() in the REST Api?
-
Anonymous
commented
I would like to be able to add a row to a table called say: DataSource and then use the data in this table as a dynamic programmable parameter.
I can then:
- publish a .pbix file through REST API
- update DataSource table through REST API
- On refresh new DataSource path is used to get dataThis means I can completely automate publishing of PowerBI Dashboards for new clients.