If I merge two columns from an expanded field can I delete the unmerged columns?

[Anonymous]

So I have imported a SharePoint list into Power BI and there are some name lookup columns. I have expanded these to First Name and Surname columns, then merged them into one column.

The Query has retained the two unmerged columns, but I don't really want them. If I delete them, and new entries are added to the sharepoint list, will PowerBI know to pull through the same data in the format I have specified, or will it kick off?

Thanks 🙂

Jemma

[PattemManohar · Accepted solution]

@Anonymous If you have done all these steps in "Power Query" then it will have a list of steps that was performed on the data after imported. So if there is any new data (after refresh) then it will apply the same steps again. You no need to do all these again.