Forum Discussion
Remove rows based on another table
Chavas , In most of the connection, you have an advance option, you can give a query there. so add this query using new connection route
Chavas , as far as I know, the Power Query way to merge the table using an inner join, if need create a column using header and filter blank
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
So merge the header(after rows from header deleted) with details using inner join and expand and take status from the header. Ideally, it should reduce the rows. If not filter the rows here too based on the status.
Thansk amitchandak I have tried with the Merge option, but it does not work because I want to prevent getting ALL the data each refresh. So this needs to process everything but I want to remove the rows based on a condition of: If Task.Value=Incident.Value, keep row, remove row.