Forum Discussion
General question about transforming columns in Query
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.
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.
2 Replies
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.