Skip to main content

Power BI

Under Review

Update rows Rest API

Vote (228) Share
Sauskethorpido's profile image

Sauskethorpido on 18 Aug 2015 03:46:14

Provide API to update rows in an uploaded dataset

Administrator on 21 Dec 2016 11:03:57

Asked the team to look into this

Comments (39)
Sauskethorpido's profile image Profile Picture

Alex on 05 Jul 2020 23:40:16

RE: Update rows Rest API

deto - we need to be able to update datasets. Otherwise this feature is unusable for us as an ISV

Sauskethorpido's profile image Profile Picture

Power BI User on 05 Jul 2020 23:38:47

RE: Update rows Rest API

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.

Sauskethorpido's profile image Profile Picture

Praveen Mishra on 05 Jul 2020 23:37:51

RE: Update rows Rest API

Must have feature any update on it by when this will be available.

Sauskethorpido's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:09

RE: Update rows Rest API

Yes.. this is a must to have feature. Cant imagine basic CRUD operations missing in a microsoft product.

Sauskethorpido's profile image Profile Picture

Raju on 05 Jul 2020 23:28:42

RE: Update rows Rest API

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.

Sauskethorpido's profile image Profile Picture

martin knight on 05 Jul 2020 23:26:52

RE: Update rows Rest API

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.

Sauskethorpido's profile image Profile Picture

Alison Hughes on 05 Jul 2020 23:19:55

RE: Update rows Rest API

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.

Sauskethorpido's profile image Profile Picture

Favna on 05 Jul 2020 23:17:47

RE: Update rows Rest API

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)?

Sauskethorpido's profile image Profile Picture

Joris on 05 Jul 2020 23:14:33

RE: Update rows Rest API

'+1 Vote. This is essential for syncing with evolving data sources

Sauskethorpido's profile image Profile Picture

Steve Menke on 05 Jul 2020 23:08:20

RE: Update rows Rest API

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.