Delete a row via Power BI REST API

[MbProg]

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.

[Anonymous]

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.

[lbendlin]

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

[v-chuncz-msft]

@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.