Deleted Rows

[EVEAdmin]

In my data model, I will delete rows based on whether a column contains a text value.

What happens if the value is then edited and it does not match the criteria anymore?

Will the row be imported in the next data refresh?

Many thanks.

[EVEAdmin]

@ImkeF many thanks, appreciated. It clears a doubt I've had for a while.

[ImkeF · Accepted solution]

Hi @EVEAdmin ,
yes, the row will be loaded. With any data ordinary data refresh, Power Query is not aware of anything that has happened in any refresh before.

[amitchandak]

Thanks @ImkeF 

[amitchandak]

@EVEAdmin , a a new new step like

Table.SelectRows(
Table1,
each Text.Contains([Column], "Text")
)

or create a new column with Text.Contains and then use filter

[EVEAdmin]

@amitchandak many thanks, you often replied my queries, appreciated.

If I understand well, once a row is deleted, even if its content is edited by a user in the application and does not match the criteria, it will still be deleted on the next refresh. Is that right?

In my model, I would like to delete rows where ColumnNotes contains "some text".
However, if a user deletes "some text" from ColumnNotes, after I imported data to Power BI, then the row must not be deleted anymore, on the next data refresh.
Tnx again.

[amitchandak]

@EVEAdmin , Oh, I missed must not delete it in the next load. Let me check it out. Let us check with the Power query expert.

@ImkeF , please help with this