Will columns created via split by position remain after refreshing imported data?

[RCro]

Hi all!

As the subject line suggests, I've created 2 new columns in a dataset by splitting an original column using split by position. However, I am concerned that when I update the dataset (import storage) and add new data, these columns will be deleted and I will need to recreate them. Is this the case? Will these columns be deleted if I update the datasets and add new data?

If so, is there a solution that avoids manually recreating the columns on every update?

Thanks in advance for the help!

Kind regards,
Rob

[BA_Pete · Accepted solution]

Hi Rob,

No, your columns won't be deleted. Any transformations you do in Power Query occur AFTER the new data has been imported i.e. if you select your SOURCE step, this is the current/new data as it has been imported. All the subsequent steps are then performed on that data in the order they feature in the APPLIED STEPS list.

The only thing that may break is if your new/refreshed data no longer includes the column(s) upon which your transformations are performed, or if the column name(s) get changed at source etc.

Pete