General question about transforming columns in Query

[Anonymous]

Hi,

I merged two columns and changed the column type in Query. If I add more data to the same sheet of existing data, will it automatically merge the two columns in the query? For the record my data source is an excel file. 

[adudani · Accepted solution]

Hi @Anonymous ,

Any applied steps to query , once closed , applied and with the pbix saved will be retained.

When "Refresh Data" is clicked on, the connected source is reached out to collect and load the data.

So, yes I think it should work unless there is an error generated in the query when the new data is loaded or any other context you would like to provide.

[Anonymous]

Awesome, thank you!