Best Steps to Use the Same Power Query inside EXCEL for another file. RRS feed

  • Question

  • Hi folks, 

    I have an Excel File that includes the Power Query by using the Excel Data-Show Query options. I need to use the same

    Excel file but to open a different datasource. I had to split my datasource (Folder of 1000 EXCEL files) into smaller folders to working on it in Excel is possible. so basically, I'm going through the below exercise but not sure if it is the most effecient way?

    1) Copy the Excel File with the Power Query as "next 200 records".

    2) Open the "next 200 record"

    3) Select the Edit Option and change the data source to the folder that includes the next 200 Excel files.

    4) At this time, an automatic Refresh starts. 


    The Copy Excel file still includes the data from the previous first 200 record. 

    Am I doing the above correctly?

    Is there a 2 GB limitation when the Load/Close option is selected and Excel/Power Query is trying to build the final file?

    Thank you so much for your time.


    Monday, December 16, 2019 9:07 PM