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 ...
Hi, bilingual
I'd like to suggest you try the following data reduction techniques:
- Remove unnecessary columns
- Remove unnecessary rows
- Group by and summarize
- Optimize column data types
- Preference for custom columns
- Disable Power Query query load
- Disable auto date/time
- Switch to Mixed mode
For further information, you may refer to the following document.
Data reduction techniques for Import modeling
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.