Forum Discussion

EVEAdmin's avatar
EVEAdmin
Post Patron
3 years ago
Solved

Deleted 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 in the next data refresh?

 

Many thanks.

Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    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.

6 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    3 years ago

    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's avatar
    amitchandak
    Super User
    3 years ago

    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's avatar
      EVEAdmin
      Post Patron
      3 years ago

      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's avatar
        amitchandak
        Super User
        3 years ago

        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