topic Delete a row via Power BI REST API in Developer

Delete a row via Power BI REST API

MbProg — Fri, 09 Sep 2016 08:23:04 GMT

A very important question: In Power BI REST API I am able to insert and delete rows.

I want to user the delete function, but as I have seen, I am just able all the rows in table. Can I delete a specific row?

Is there a way to update a row in my datatable?

I wanted to develope such kind of live update of my datasets, and in my source new rows are inserted and existing rows are updated. So I have to find a way to update the rows in the dataset in Power BI Service. But deleting all rows in the table is not a solution because we have about half a million rows.

Re: Delete a row via Power BI REST API

v-chuncz-msft — Mon, 12 Sep 2016 10:47:40 GMT

@MbProg,

I see you raised a same thread at Power BI User Group Norway. Is it possible to change the data source? Then you could probably use Direct Query.

Re: Delete a row via Power BI REST API

Anonymous — Tue, 16 Jun 2020 13:02:52 GMT

Hi,

Do you have any solution to delete specific rows from the dataset using REST API ?

I am looking for same solution, please help me if you have solution for this.

Re: Delete a row via Power BI REST API

lbendlin — Wed, 17 Jun 2020 03:36:54 GMT

Your tenant must support XMLA write for that to be possible.