Skip to main content

Power BI

New

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

Vote (67) 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

deadffe7 792e-4f61-abf3-76857b574446 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

352a797b a71b-479a-b062-b9b1a227de57 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

e6aacfb2 6798-44a8-bf1c-7a9251efbf04 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

aefd5ba9 842d-4af8-a45a-80852ba8ea7a 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

47b68335 7814-4c5c-886e-33b85ed28dbd 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.