Forum Discussion
Append large data files - best practice?
Hi, i have used Power Query in order to combine historical data in our organization. The problem is the only form of export from SAP webi is either excel or csv format. As every months has about ...
I am also interested in finding the best practice in a case like this.
So far, I have split a large fact table by year, turned off refresh for prior years and appended the data in PowerQuery.
I am not sure if this will improve performance.