Hi,
I have a query which appends multiple CSV files and then perform various steps to transform the data.
please note that these CSV file data which are getting appended are static and does not need refresh, however the steps in the query are dynamic based on values from other data table.
So everytime, I refresh the query to reflect the changes, it first appends the csv files and then run the query, I want to avoid the step of appending the CSV files as it is not required and takes lot of time due to huge data size.
The below step is the first step in the query which appends the CSV files, is there a way I can avoid the appending of files.
= Table.Combine({#"Data - 2018_Intl", #"Data- 2019_Intl", #"Data- 2020", #"Data- 2021", #"Data- 2022", #"Data- 2022 Intl"})
Any help would be appreciated. Thanks.
