Skip to main content

Power BI

Under Review

Update rows Rest API

Vote (206) 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 (38)
Sauskethorpido's profile image Profile Picture

414e5083 df27-4a83-9768-2905c4e3c77e 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

91f6c65e c89d-4367-974e-a29c4e1cade6 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

733dddf8 fc1c-4c25-b111-18b955c3fc66 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

6695c63c f721-4112-9ac3-c7d9099b8c2b 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

54be44e6 541d-4825-9979-9779d88c55c5 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

cfc4bde5 b068-4177-a908-9beb50a780fe 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

6d1366a2 d985-458d-bac3-e1d562699535 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

3c2b7943 db5c-450b-9f8a-43854b36b753 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

b8e380b9 2449-46ac-b8fb-5360d6ef172c 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.

Sauskethorpido's profile image Profile Picture

352a797b a71b-479a-b062-b9b1a227de57 on 05 Jul 2020 22:57:20

RE: Update rows Rest API

'@charles sterling (Admin, Microsoft Power BI)

Any update on this feature request? Is this feature coming or it's discarded by the team?