Forum Discussion
EVEAdmin
Post Patron
Post PatronDeleted Rows
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 i...
amitchandak
Super User
Super UserEVEAdmin , 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
EVEAdminPost Patron
Post Patronamitchandak 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