Forum Discussion

vishnu-Prasad's avatar
vishnu-Prasad
Frequent Visitor
3 years ago

Issue with data load while consolidating multiple excels

Hi team,   I having nearly 135 excel files which are consolidated based on a specific KPI sheet via power query. however the data load is taking too much time to load & close.   Please advise how...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
ValtteriN's avatar
ValtteriN
Community Champion
3 years ago

Here are some general points:

  1. Reduce the amount of data being imported: Consider importing only the data that you need for your analysis. If you have a large data set, you can use Power Query's filtering and grouping options to extract only the data you need.

  2. Remove unnecessary columns and rows: In Power Query, you can remove columns and rows that you don't need. This can help reduce the file size and speed up the data load time.

  • vishnu-Prasad's avatar
    vishnu-Prasad
    Frequent Visitor
    3 years ago

    Hi ValtteriN,

    Thanks for the reply.. 

    Yes, we already did all the things you mentioned and also limit the ROWS for consolidation. eventhough, after all these things. the load is very slow. 

    on thing we change is the source location folder. last time it is test  and now, we did with the production folder..