Hi Melissa / Lucian,
I tried the approach of importing the historical data merged into one CSV format, and then appending the current year data (.xlsx format). The approach works and time taken to refresh has halved. I also checked the option for quick load in the query properties window. Don’t know if the quick load option also helped to it. Thank you both for suggestions.
2 Likes