Remove Specific Rows from a power BI dataset using REST API

[Anonymous]

Hi,

I am trying to build a real time dashbord in power BI. I am able to push rows and tables using power BI REST API, but I am not able to remove specific rows on condition because the REST API only supports to delete all rows in that table. 

Is there a way to delete specific rows based on condition using power BI REST API ?

[collinq]

Hi @Anonymous ,

I do not believe that the API has that ability.  In the Power Query Editor or you could use the Remove Rows and do the top or bottom or even a range of rows.  Or, you can use a filter in Power Query to eliminate certain rows.

That said, maybe you could use a DAX function to remove the rows because you are trying to make this happen in real-time so if there was a DAX function on the report that removes certain rows (or, technically, you could use a Filter on the Report page itself).

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!