Skip to main content

Power BI

Needs Votes

Option to delete a subset of rows from a table via REST API

Vote (68) Share
Axel Evers's profile image

Axel Evers on 14 Aug 2015 20:24:18

When using a on premises service to push data to Power BI it would be very helpful to have an option to get rid of old data. Therefore an option to delete a subset of the rows (for example: where timestamp > 24h) would be awesome!

Comments (5)
Axel Evers's profile image Profile Picture

Shawn Eary on 06 Jul 2020 00:12:19

RE: Option to delete a subset of rows from a table via REST API

Not sure if this is exactly the same thing, but I need a way to delete rows from Straining Push Datasets. I think Stacy May requested something like this over here:
https://feedback.azure.com/forums/287593-logic-apps/suggestions/34254820-delete-rows-from-power-bi-dataset

Axel Evers's profile image Profile Picture

Zeeshan Qadir on 05 Jul 2020 22:57:20

RE: Option to delete a subset of rows from a table via REST API

Any update on this request?

Axel Evers's profile image Profile Picture

nupur solanki on 05 Jul 2020 22:47:36

RE: Option to delete a subset of rows from a table via REST API

hiii
i also want solution for delete particular row.plz reply for solution

Axel Evers's profile image Profile Picture

Yassar Khan on 05 Jul 2020 22:17:53

RE: Option to delete a subset of rows from a table via REST API

Any update on this? Can the PBI staff please reply in the comments so we know this is something they're working on.

This is especially painful when you have to re-create a very large dataset when new rows are added.

Axel Evers's profile image Profile Picture

Jesse Pangburn on 05 Jul 2020 22:12:56

RE: Option to delete a subset of rows from a table via REST API

Agree, lack of this is harming the ability to use the REST API to keep a dataset mirrored with a view of an on premises (or cloud) service. There's a separate suggestion for update, but this delete goes hand in hand. You'd want to be able to delete by a row id as well as what the OP said.