Forum Discussion
EVEAdmin
Post Patron
3 years agoDeleted 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...
EVEAdmin
Post Patron
3 years agoamitchandak 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
Super User
3 years agoEVEAdmin , 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