Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Changing Source from one Excel File to a Folder

Hey guys,

I've got this Power Query which has its source connected to a single Excel workbook.
I'd like to append several of these workbooks, which are located all in the same folder, into one source file.
Without the need to implement all the steps that I've done to this single file.


Is this possible?

With kind regards,

Lazzanova

  • Hi Anonymous ,
    Yes, use the folder connector, and combine the data as your source.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos πŸ‘are nice too.
    Nathaniel

     

     

1 Reply

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion

    Hi Anonymous ,
    Yes, use the folder connector, and combine the data as your source.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos πŸ‘are nice too.
    Nathaniel